Free Desktop-Specialist Exam Questions and Answers (Page: 5)

QUESTION: 21

How would you calculate GDP per capita in Tableau?

SUM([GDP]/[POPULATION])
SUM([Population]/[GDP]])
SUM([GDP]*[POPULATION])
SUM([GDP]) / SUM([Population])

Answer(s): D

Explanation:

GDP / Population = GDP Per Capita

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

QUESTION: 22

_______________ 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 Prep
Tableau Public
Tableau myServer

Answer(s): 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.

Reference:

https://www.tableau.com/learn/webinars/introduction-tableau-server

Reveal Solution Next Question

QUESTION: 23

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
March 2018
December 2017
January 2018

Answer(s): D

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/

Reveal Solution Next Question

QUESTION: 24

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
1,461
112,256
1,222

Answer(s): 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!

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

Reveal Solution Next Question

QUESTION: 25

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%
95.12%
97.12%
99.46%

Answer(s): C

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 :