Tableau Desktop Certified Associate Exam Questions

Page: 1 / 14
Total 108 questions
Question 1

How to add reference lines in a view? (Select correct two answers)



Answer : A, D

Using Analytics pane:

Right Click on Axis and Add Reference Line:


Question 2

Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country. Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?



Answer : A

Add the Country population excel sheet as a New Data Source.

Select column 1960 to 2013, click on Pivot.

Rename the new fields as Year and population.

Go to Data ->Edit Blend Relationship

Click on Custom and Add

Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.

Drop the year to the filters shelf and only enter 1963.

Drop Country and Number of Records / volerup(Count) field to the view.

And drop population to the view from the secondary data source. Your view will look like this:


Question 3

You need to create a filled map using the City field, you drop the City field to your view. And you get the location error 'Ambigious', what does it mean, and how you will fix this issue?

Larger image



Answer : C

Click on the State/Province list, and select the State. So Tableau will recognize the city as part of the states in the Country/Region United States.


Question 4

Connect to the "Global Superstore" data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?



Answer : B

Drop the State field to a view, you will get >1k unknown.

Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone.

Also, drop the Order Date to the Filters Shelf and choose Years as:

Check for the Year 2013.

Drop the Sales field to the Label in the Marks card, your view should look like this:

Now use the Lasso Selection tool from the Map tools:

And create the group of states as per our answer options.

Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.

Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.


Question 5

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?



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 6

Using the Profit Analysis Dashboard twbx file, find out the profit recorded in October 2016 by California State in the West region? You can add the functionality to the dashboard.



Answer : C

Select California State from the Map

Topic 2, Exam Pool B

Download the Dataset from here:

https://drive.google.com/file/d/1z7LPBQNPWHChteShl0QL3yu_JcvstLGl/view?usp=sharing

Use the above data set to answers the questions under Exam Pool B.


Question 7

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?



Answer : A

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.


Page:    1 / 14   
Total 108 questions