BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Tableau Exam Desktop-Certified-Associate Topic 7 Question 22 Discussion

Actual exam question for Tableau's Desktop-Certified-Associate exam
Question #: 22
Topic #: 7
[All Desktop-Certified-Associate Questions]

Connect to the "World Cup Results" and use tables WorldCupMatches, WorldCups. Which of the following year had the highest percentage of Away goals? Consider only those years when the host country did not win the world cup.

Show Suggested Answer Hide Answer
Suggested Answer: A

In WorldCupMatches table, we have the information of Away goals, and in the WorldCups

table, we have the information of the Winner team and goal scored.

In WorldCups, there is only row for each year. But in WorldCupMatches, there is a separate

row for each match. This is the perfect example to use blend as here we need to first

aggregate the data from WorldCupMatches table.

Let's establish the blend relationship between these two data sources, on the basis of Country

and Year.

Let's use WorldCups as the primary data source, so add the field from this data source to the

view. Drop Year to Rows and change it discrete. Drop Country and Winner field as well to the

rows.

In WorldCupMatches data source, create a calculated field :

Drop this field to the Text, and format it so that it will be shown in percentage.

Out of the given options, only in 1934 host country won the world cup

2010 is the correct answer.


Contribute your Thoughts:

Cyril
1 months ago
Hmm, this is a tough one. I'm going to have to go with A) 2010 - the World Cup in South Africa, where the home team didn't win. I hope my luck is better than my futbol skills!
upvoted 0 times
...
Celeste
2 months ago
D) 1934 - the World Cup in Italy, where the host team didn't win? That's got to be the one with the highest away goal percentage. I'm feeling lucky with this pick!
upvoted 0 times
Miesha
2 days ago
Let's see if 1934 was indeed the year with the highest away goal percentage.
upvoted 0 times
...
Dante
5 days ago
I agree, 1934 seems like the best option.
upvoted 0 times
...
Jolene
6 days ago
I'm going with 2002, just a gut feeling.
upvoted 0 times
...
Giuseppe
12 days ago
I think 1934 is a good choice, Italy didn't win that year.
upvoted 0 times
...
...
Chauncey
2 months ago
I'm feeling confident about this one. The answer has to be C) 1994 - the first World Cup in the US, where the home team didn't win. Those away goals must have been flying in!
upvoted 0 times
...
Golda
2 months ago
Hmm, this seems like a tricky one. I'm going to go with B) 2002 - the World Cup in Korea and Japan was a bit of a wild ride, with lots of surprising results!
upvoted 0 times
Alyce
20 days ago
It's possible, let's check the data to be sure.
upvoted 0 times
...
Janessa
21 days ago
Do you think that affected the percentage of Away goals?
upvoted 0 times
...
Sheron
22 days ago
I agree, there were definitely some unexpected outcomes.
upvoted 0 times
...
Terina
1 months ago
I think 2002 was a crazy year for the World Cup.
upvoted 0 times
...
...
Tracey
2 months ago
I'm not sure, but I think the host country did not win in 1994, so maybe the answer is C) 1994.
upvoted 0 times
...
Kristeen
2 months ago
I disagree, I believe the correct answer is A) 2010.
upvoted 0 times
...
Adaline
2 months ago
I think the answer is B) 2002.
upvoted 0 times
...

Save Cancel