QUESTION: 13 Exam Topic: 1, Exam Pool A

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.

Missy Franklin
Usain Bolt
Dana Vollmer
Michael Phelps

Answer(s): D

Explanation:

Find out how many gold medals each athlete won in the 2008 Olympics

Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:

Now we need work on "won at least 4 golds in 2012 Olympics" Drop years to filters and select 2012.
Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals)

Final view:

Reveal Solution Next Question

QUESTION: 14 Exam Topic: 1, Exam Pool A

View Related Case Study

Connect to the "Global Superstore" data source and use the Orders table. Find out the customers who placed their first order in 2013 and what is the total sales value of these customers in the same year?

$414,302
$2,263,137
$483,269
$2,385,198

Answer(s): C

Explanation:

Find the minimum order date for each customer

Drop the order date, Min Order date, and Sales to the view

$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.