Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 3
List of questions
Question 21

To create this view, what all you have to do from the following options?
Larger image
Explanation:
Option 1 - It is not valid, as we are not showing Columns Totals on Top.
Option 3 - It is not valid, as we are modifying the row divider settings and not the column divider settings.
Rest are true.
Question 22

Connect to the 'Significant Volcano Eruption' data source. Create a histogram using field Death and having a bin size of 500. Find out which country reported 9 deaths in the bin of 0-500?
Explanation:
Select the measure "Death" and go to the Show Me and Click on Histogram
When we are binning the measure, it will create the dimension, so you get a new dimension as Death (bin). Right-click on this and click on Edit. Update the size of bins to 500.
Drop the Country to the color, so our view will look like this:
Now drop the Country to the filter and select 4 countries mentioned in our options.
Hover the bar, it shows the United States has reported 9 deaths.
Question 23

In which of the following scenarios you should use the blend?
Explanation:
Union - The data to combine has the same structure but consists of data of different years.
Blend - The data to combine is at a different level of detail.
Question 24

How the ATTR() is defined in Tableau?
Explanation:
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE '*' END
Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function
Question 25

To create a choropleth map, your data source should include the following types of information?
Explanation:
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_howto_choropleth.htm
Question 26

How to add reference lines in a view? (Select correct two answers)
Explanation:
Using Analytics pane:
Right Click on Axis and Add Reference Line:
Question 27

When it is recommended to create multiple table extracts?
Explanation:
It is recommended to create multiple table extracts when row-level security needs to be enforced.
Refer: https://www.tableau.com/about/blog/2018/10/you-can-now-choose-multiple-table-storage-extracts-94776
Question 28

Connect to the 'Global Superstore' data source and use the Orders table. Find out in which year the furniture sales were more than the average sales of that year?
Explanation:
Drop Order Date to columns, Category to Rows, and Sales to Text.
Go to Analysis -> Totals -> Show Columns Grand Total
Update Total All Using to Average:
In the year 2012, the furniture sales were more than the average sales of that year.
Question 29

Which of the following is true about spatial files?
Explanation:
All are false here.
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_shapefiles.htm
Question 30

When we create a filter action in a dashboard, what all we must specify so that it will work?
Explanation:
Even if you don't select the target filters, your filter action will work. Rest all you need to provide so that it will work.
Question