Tableau Desktop Certified Associate Exam Practice Test Instant Access

Question 1

When we create a filter action in a dashboard, what all we must specify so that it will work?

ASource Sheet

BTarget Sheet

CRun action on

DTarget filter on Selected fields

Answer : A, B, C

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 2

Connect to the "Global Superstore" data source and use the Orders table. Find out the customers who placed their first order in 2013 and what is the total sales value of these customers in the same year?

A$414,302

B$2,263,137

C$483,269

D$2,385,198

Answer : C

Find the minimum order date for each customer

Drop the order date, Min Order date, and Sales to the view

$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.

Question 3

Using the Profit Analysis Dashboard twbx file, find out the 5th most profitable product in the state of New York? You can add the functionality to the dashboard.

AGBC DocuBind TL300 Electric Binding System

BCanon imageCLASS 2200 Advanced Copier

CFellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind

DHP Designjet T520 Inkjet Large Format Printer - 24' Color

Answer : A

Select New York State, you are getting only 3 products, and not 5.

You need to add State as a Context filter in the Top 5 profitable products View. For that, go to the Top 5 profitable products sheet. (click on small arrow)

Select Add to Context on the State filter

Question 4

Which of the following is true about spatial files?

AYou cannot create a dual-axis chart using spatial data

BYou cannot join spatial data source with the non-spatial data source

CYou cannot apply filters in your view if it is creates using the spatial data source

DNone of the above

Answer : D

All are false here.

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

Question 5

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.

A-0.56

B-0.67

C-0.69

D-0.58

Answer : B

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 6

Connect to the "Life Expectancy at birth" data source, combine sheets Data_20th century and Data_21st century. Find the moving average for the average life expectancy for 10 years before 2000 and 10 years after 2000 for New Zealand.

A78.56

B78.286

C78.03

D78.303

Answer : B

Connect to the 'Life Expectancy at birth' excel file, drag Data_20th Century sheet to the canvas. If you find data columns are not correct.

Use the data Interpreter, it will correct the data.

Select the column 1960 to 2000. And Click on the Pivot option

Rename the two new columns as 'Years' and 'Life Expectancy'

Create a Union by dragging the sheet Data_21st Century to Data_20th Century, once you see the orange block for union.

Now, select column 2001 to 2013 and Select Add data to Pivot.

Select Country and Country Name field, Merge these fields.

Rename the merged field as Country.

Let's create the view.

Drop the country to the Filters and Select New Zealand. Drop the years to the columns and 'Life Expectancy' to the Text marks card. Change the aggregation to Avg (it won't make a difference here).

Right-Click on Life Expectancy -> Quick Table Calc -> Moving Average

Again, right-click on it and edit the table calculation.

Update the values as:

Result is:

Question 7

Connect to the "Global Superstore" data source and use the Orders table. Create a view using Profit and Sales. Find out which sub-category is above the profit median but below the sales median value?

AAppliances

BBinders

CStorage

DTables

Answer : B

Drop Sales to columns and profit to rows, and Sub-Category to details.

Add two reference lines, one on the sales axis:

Add similarly on profit axis as well.

Out of the following options, only the Binders sub-category is above the profit median but below the sales median value.