Free Tableau Desktop-Certified-Associate Exam Actual Questions

The questions for Desktop-Certified-Associate were last updated On May 2, 2024

Question No. 1

__________ function rounds a number to the nearest integer of equal or lesser value.

Show Answer Hide Answer
Correct Answer: A

Question No. 2

Connect to the "Global Superstore" data source and use the Orders table. Create a box-plots to show the sales distribution for each ship mode. Which of the following ship modes have the same median?

Show Answer Hide Answer
Correct Answer: A, B

Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate

measures)

From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.

Hover on each of the boxes:

Median for the First Class and Same Day ship modes are 84.


Question No. 3

Using the Regional Dashboard twbx file, find out the percentage of average obesity increases when 1% average increase in the physical inactivity in the New York state of the Northeast region?

Show Answer Hide Answer
Correct Answer: D

Open Regional Dashboard twbx file, and select the region as Northeast and state as New York:

Hover the trend line of Obesity correlation with exercise chart, 0.57 percentage of average

obesity increases when 1% average increase in the physical inactivity in the Northeast Region.

However, we have to find out for the New York State. Currently, when you have selected the

New York state, the trend lines have not been recalculated.

To recalculate it, right-click on the trend line and click on Edit All Trend Lines:

In Trend Line Options, select the Show recalculated line check box:

Hover the trend line of Obesity correlation with exercise chart, 0.40 percentage of average

obesity increases when 1% average increase in the physical inactivity in the New York State in

the Northeast Region.


Question No. 4

Using the Regional Dashboard twbx file, consider the Obesity dashboard to find out how many counties in North Carolina are having an obesity rate that is 8% below the regional obesity rate?

Show Answer Hide Answer
Correct Answer: A

Here we have to use the Obesity View only, so let's go to that sheet:

Click on go to sheet as per above.

Edit the State filter and select only North Carolina:

Duplicate this sheet as Crosstab

3 counties in North Carolina are having an obesity rate that is 8% below the regional obesity

rate.

Note: For dashboard questions, I prefer to follow above approach wherever it is applicable. I

find it easy to get the answers.


Question No. 5

Select the correct options that allow you to ensure that your Phone layout automatically reflects changes to the Default dashboard?

Show Answer Hide Answer
Correct Answer: A, C

Refer: https://help.tableau.com/current/pro/desktop/en-us/dashboards_dsd_create.htm

Go to the section- Phone layouts and the Default dashboard