Tableau TDS-C01 Practice Test - Questions Answers, Page 4
List of questions
Question 31
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
True or False: It is possible to add a field to more than one hierarchy
Explanation:
Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.
Question 32
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
How would you calculate GDP per capita in Tableau?
Explanation:
GDP / Population = GDP Per Capita
Here Sum is a function, / and + are operators. On the bottom there are comments.
Question 33
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.
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.
Question 34
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Explanation:
Follow the steps to get the correct answer : January 2018
We are talking about dates, so use the Time series sheet as follows:
Next, the following should be your view and clearly, January 2018 is the lowest point:
Read more about dates: https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/
Question 35
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
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!
The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October
Question 36
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
Explanation:
Not too tough. Follow along the steps:
Drag Color to Filter and choose Red:
3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
And your final view will look like :
Question 37
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
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:
Question 38
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
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:
It is clear that October with -55.3% had the lowest Year on Year growth.
Question 39
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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)?
Explanation:
Since you need BOTH State and the YEAR, we need to use an Inner Join.
Follow the steps below:
Question 40
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Explanation:
Phew! Tricky one! You needed to use filters in this one.
Follow along:
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 :
ii) Next, drag Color to Filters and Choose only White:
iii) Next, dragStateIDto Filters, and choose New York (NY):
And Voila! We have our answer as follows:
iv) Last, drag Sales to Label:
Question