ExamGecko
Home / Tableau / TDS-C01 / List of questions
Ask Question

Tableau TDS-C01 Practice Test - Questions Answers, Page 4

List of questions

Question 31

Report
Export
Collapse

True or False: It is possible to add a field to more than one hierarchy

True
True
False
False
Suggested answer: A

Explanation:

Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.

asked 23/09/2024
Luis Alfonso Rodriguez Castro
35 questions

Question 32

Report
Export
Collapse

How would you calculate GDP per capita in Tableau?

SUM([GDP]/[POPULATION])
SUM([GDP]/[POPULATION])
SUM([Population]/[GDP]])
SUM([Population]/[GDP]])
SUM([GDP]*[POPULATION])
SUM([GDP]*[POPULATION])
SUM([GDP]) / SUM([Population])
SUM([GDP]) / SUM([Population])
Suggested answer: D

Explanation:

GDP / Population = GDP Per Capita

Tableau TDS-C01 image Question 32 explanation 76375 09232024004744000000

Here Sum is a function, / and + are operators. On the bottom there are comments.

asked 23/09/2024
Sorin Craia
39 questions

Question 33

Report
Export
Collapse

_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

Tableau Server
Tableau Server
Tableau Prep
Tableau Prep
Tableau Public
Tableau Public
Tableau myServer
Tableau myServer
Suggested answer: A

Explanation:

Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

asked 23/09/2024
Juan Garrido Soler
32 questions

Question 34

Report
Export
Collapse

Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing

Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

September 2017
September 2017
March 2018
March 2018
December 2017
December 2017
January 2018
January 2018
Suggested answer: D

Explanation:

Follow the steps to get the correct answer : January 2018

Tableau TDS-C01 image Question 34 explanation 76377 09232024004744000000

We are talking about dates, so use the Time series sheet as follows:

Tableau TDS-C01 image Question 34 explanation 76377 09232024004744000000

Next, the following should be your view and clearly, January 2018 is the lowest point:

Tableau TDS-C01 image Question 34 explanation 76377 09232024004744000000

Read more about dates: https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/

asked 23/09/2024
Wilco Gent
32 questions

Question 35

Report
Export
Collapse

Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

111,060
111,060
1,461
1,461
112,256
112,256
1,222
1,222
Suggested answer: C

Explanation:

If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.

To reach the correct answer, follow the steps below:

1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!

Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!

Tableau TDS-C01 image Question 35 explanation 76378 09232024004744000000

Tableau TDS-C01 image Question 35 explanation 76378 09232024004744000000

The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

Tableau TDS-C01 image Question 35 explanation 76378 09232024004744000000

asked 23/09/2024
Tom Starren
43 questions

Question 36

Report
Export
Collapse

Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

96.46%
96.46%
95.12%
95.12%
97.12%
97.12%
99.46%
99.46%
Suggested answer: C

Explanation:

Not too tough. Follow along the steps:

Drag Color to Filter and choose Red:

Tableau TDS-C01 image Question 36 explanation 76379 09232024004744000000

Tableau TDS-C01 image Question 36 explanation 76379 09232024004744000000

3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:

Tableau TDS-C01 image Question 36 explanation 76379 09232024004744000000

And your final view will look like :

Tableau TDS-C01 image Question 36 explanation 76379 09232024004744000000

asked 23/09/2024
Mohamed Abdul Haq Mohamed Akram
45 questions

Question 37

Report
Export
Collapse

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

October
October
September
September
July
July
June
June
Suggested answer: A

Explanation:

Follow along:

1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.

For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.

The view should now look like:

asked 23/09/2024
Prenolan Kamiah
41 questions

Question 38

Report
Export
Collapse

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

October
October
September
September
July
July
June
June
Suggested answer: A

Explanation:

Follow along:

1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.

For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.

The view should now look like:

Tableau TDS-C01 image Question 38 explanation 76381 09232024004744000000

It is clear that October with -55.3% had the lowest Year on Year growth.

asked 23/09/2024
Letlhogonolo Phiri
35 questions

Question 39

Report
Export
Collapse

Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

592,593
592,593
293,202
293,202
416,702
416,702
336,908
336,908
Suggested answer: C

Explanation:

Since you need BOTH State and the YEAR, we need to use an Inner Join.

Follow the steps below:

asked 23/09/2024
RALPH KOH
28 questions

Question 40

Report
Export
Collapse

Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

$16,581
$16,581
(Correct)
(Correct)
$147,950
$147,950
$48,115
$48,115
$33,768
$33,768
Suggested answer: A

Explanation:

Phew! Tricky one! You needed to use filters in this one.

Follow along:

Tableau TDS-C01 image Question 40 explanation 76383 09232024004744000000

2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!

i) First dragAssortmentto Filters, and select only Phones :

Tableau TDS-C01 image Question 40 explanation 76383 09232024004744000000

ii) Next, drag Color to Filters and Choose only White:

Tableau TDS-C01 image Question 40 explanation 76383 09232024004744000000

iii) Next, dragStateIDto Filters, and choose New York (NY):

Tableau TDS-C01 image Question 40 explanation 76383 09232024004744000000

Tableau TDS-C01 image Question 40 explanation 76383 09232024004744000000

And Voila! We have our answer as follows:

Tableau TDS-C01 image Question 40 explanation 76383 09232024004744000000

iv) Last, drag Sales to Label:

asked 23/09/2024
Eb Store
34 questions
Total 318 questions
Go to page: of 32
Search