Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 4

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.

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.

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.

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.

Go to the Map -> Map Layer

Cities Borders is not valid.

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.

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.

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

Refer section "Quality Metrics" at https://help.tableau.com/current/pro/desktop/enus/

forecast_describe.htm