Deal of The Day! 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 1 Question 4 Discussion

Actual exam question for Tableau's Desktop-Certified-Associate exam
Question #: 4
Topic #: 1
[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:

Tammara
4 months ago
Yes, I remember that South Africa hosted the 2010 World Cup and Spain won it. So 2010 is the year with the highest percentage of Away goals.
upvoted 0 times
...
Lonny
4 months ago
That makes sense. So the highest percentage of Away goals would be in 2010 since Spain won that year and they were not the host country.
upvoted 0 times
...
Jamey
4 months ago
I believe 1994 is the correct answer because Brazil won that year and they were the host country.
upvoted 0 times
...
Tammara
4 months ago
I agree, it's important to focus on those specific years. I think it could be either 2010 or 1994.
upvoted 0 times
...
Lonny
4 months ago
I think this question is tricky, we have to consider the years when the host country did not win the world cup.
upvoted 0 times
...
Jesus
4 months ago
Let's calculate and compare the percentages to be sure.
upvoted 0 times
...
Cherry
4 months ago
I agree with Kerry, 2002 was a crazy year for upsets.
upvoted 0 times
...
Kerry
5 months ago
I personally think 2002 had the highest percentage of Away goals because there were a lot of surprise wins.
upvoted 0 times
...
Jesus
5 months ago
Right, and we should only consider years when the host country did not win the World Cup.
upvoted 0 times
...
Cherry
5 months ago
Then we can calculate the percentage of Away goals for each year.
upvoted 0 times
...
Jesus
6 months ago
I think we need to first look at the World Cup Matches table to see the number of Away goals.
upvoted 0 times
...

Save Cancel