ExamGecko
Search Search Login
Home Home / Tableau / Desktop Certified Associate
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

Connect to the 'Global Superstore' data source and use the Orders table. Find out how many distinct customers have made 6 orders?
Connect to the 'Significant Volcano Eruption' data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?
How can we add Visualization in a tooltip?
In LOD calculation, we can use fields from multiple data sources (blended data source)?
Tableau automatically associates continuous fields with categorical palettes.
Connect to the Olympic Athletes data source, which athlete won at least one gold in 2008 Olympics and then won at least 4 golds in 2012 Olympics.
Connect to the 'Education' data source. Which college(s) average math, verbal, and writing scores are lesser than the overall 70% percentile in these subjects?
Connect to the 'Education' data source. Create a histogram using the Total score field and having a bin size of 100. Find out in which bin the students scored the highest verbal percentage? [Note: Verbal percentage should be calculated by considering how many marks scored in the verbal out of the total marks scored.]
Connect to the 'Global Superstore' data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?
Which of the following are valid calculations?

Question 99 - Desktop Certified Associate discussion

Report
Export

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.

A.
2010
Answers
A.
2010
B.
2002
Answers
B.
2002
C.
1994
Answers
C.
1994
D.
1934
Answers
D.
1934
Suggested answer: A

Explanation:

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 cup2010 is the correct answer.

Show Answer
asked 23/09/2024
Marcos Losa Torviso
53 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms