ExamGecko
Question list
Search
Search

List of questions

Search

Question 37 - Desktop Certified Associate discussion

Report
Export

Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?

A.
7
Answers
A.
7
B.
8
Answers
B.
8
C.
9
Answers
C.
9
D.
10
Answers
D.
10
Suggested answer: B

Explanation:

First, find the distinct sports for each country:

It will be created as a Measure, move this to Dimension

Get the distinct countries:

drop these columns to the view, final view will look like this:

The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.

asked 23/09/2024
Jonathan Correa
45 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first