Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 4
List of questions
Question 31

Which type of sort is applied in the Ship Mode field?
Larger image
Explanation:
Refer to Nested Sort section: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm
Question 32

Connect to the 'Global Superstore' data source and use the Orders table. Create a view showing sales over continuous months, find out which trend line model type provides the lowest R-squared value?
Explanation:
Drop Order Date to the Columns and change it to continuous month. Drop sales to the rows.
Go to Analytics and drop the trend line. Check for all trend lines, Linear is having the lowest R Square.
Question 33

Connect to the 'Covid data' source. Create a line chart using continuous months and new deaths. Find the Excess Kurtosis for the sum of new deaths.
Explanation:
Drop the Date to the columns and select the continuous month. Drop New Deaths to rows.
Click on the Show/Hide card and enable the Summary Card.
You will see the Summary Card on the right, if Excess Kurtosis is not enabled, click on the drop-down and select the Excess Kurtosis.
Question 34

Connect to the 'Global Superstore' data source and use the Orders table. Create a hierarchy of Segment, Category, Region. Create a crosstab using this hierarchy and add profit, profit ratio fields. Which of the following are true from the below options?
Explanation:
Create a hierarchy of Segment, Category, Region and drop it into the rows.
Create profit ratio calculated field:
Drop the profit and profit ratio fields to the view, your view will look like this:
Now let's go through each answer option.
1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.
2) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765 - It is true, the profit ratio is 2.06%, which is third-lowest.
3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.
4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False
Note: This is an easy question but time consuming, so attempt these types of questions in the end.
Question 35

Connect to the 'Significant Volcano Eruption' data source. How many volcano eruptions took place within 30 miles of the Black Peak volcano in the Alaska Peninsula?
Explanation:
Add the Latitude to Rows and Longitude to columns. Or double click on these fields.
Don't use Latitude (generated)/Longitude (generated) fields.
Drop Location to filter and select 'Alaska Peninsula'
Drop Name to the Label Marks card.
Your view will look like this:
Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.
There were no eruptions that took place with 30 miles of Black Peak.
Question 36

Which of the following map layers are available in Tableau?
Explanation:
Go to the Map -> Map Layer
Cities Borders is not valid.
Question 37

Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?
Explanation:
First, find the distinct sports for each country:
It will be created as a Measure, move this to Dimension
Get the distinct countries:
drop these columns to the view, final view will look like this:
The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.
Question 38

Connect to the Olympic Athletes data source, find out the average age of players who won at least one gold medal for the country?
Explanation:
Drop the Age to the columns and change the aggregation to AVG.
Drop Gold Medals field to filter and select All values ->
Change 1 from 0.
Question 39

Connect to the 'Significant Volcano Eruption' data source. What is the interquartile range of the distribution of Total Injuries data of the 21st century (show null values at default location)?
Explanation:
Drop year to filter shelf and select from 2000.
Drop Total injuries field to rows, go to Analysis -> Aggregated Measures (Untick this, it will disaggregate the total injuries field.
Click on Show Me, and select Box and whisker Plot.
IQR = Upper hinge - Lower hinge
Here IQR = 32 -2 = 30
Question 40

Which of the following are forecast quality metrics available in Tableau?
Explanation:
Refer section "Quality Metrics" at https://help.tableau.com/current/pro/desktop/enus/
forecast_describe.htm
Question