Tableau Desktop-Certified-Associate Exam Practice Test Instant Access

Question 1

Connect to the "Global Superstore" data source and use the Orders table. Find out how many products from the Office Supplies category are in the Top 10 most profitable product list?

Answer : B

First, create a set using the Product Name. Select the Top condition as:

Drop this Set to the filters shelf and select IN only.

Drop the Category, Top 10 profitable products and Product Name to the view:

Question 2

Which of these chart types are primarily used to compare measures against goals?

ABar-in-Bar Chart

BHistogram

CBullet graphs

DPareto chart

Answer : A, C

Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.

Question 3

Connect to the "Education" data source. Which college(s) average math, verbal, and writing scores are lesser than the overall 70% percentile in these subjects?

ABusiness

BCommunication

CEducation

DPublic Affairs

Answer : A, D

Create a bar chart using field college and Math. Change the Math aggregation to AVG.

Drop the Verbal field to Y axis, to create the combined axis chart. And change the aggregation

to Avg.

Follow the same for Writing field.

Now from the Analytics menu, drop the Distribution band to the view, select the scope as

entire table, and select the value as 70 percentiles.

Your view will look like this:

70 percentiles are 547.8

Business and public affairs have all the individual subject values lesser than 547.8.

Question 4

Connect to the "Global Superstore" data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?

ABelkin Router, USB

BCisco Smart Phone, Full Size

CNokia Smart Phone, with Caller ID

DBush Classic Bookcase, Pine

Answer : D

Drop the Product Name to the filters and Select Top 10 based on Sum of Profit.

Drop the Product Name to the Rows and Profit to the Text.

Drop the Market to the filter and select the Europe.

Your view will look like this:

Here, you are getting only 9 products.

Add Market filter to the context so that the Product Name dimension filter will be executed

after the Market filter.

View:

Question 5

Which of the following are true regarding custom geocoding and data blending?

AUsing custom geocoding, you can plot your own locations on a map but it is not true while using data blending

BIn data blending, you can use any data but custom geocoding requires text file based data

CUsing custom geocoding, you can create new geographic hierarchies but it is not true while using data blending

DYou can create new geographic roles both in data blending and custom geocoding

Answer : B, C

Refer to the quick comparison of data blending and custom geocoding -

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

Topic 3, Exam Pool C

Download the Dataset from here:

https://drive.google.com/file/d/1hGTUYyq6Y7DLt-DwxVaR4tNLS-FYvD22/view?usp=sharing

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

Question 6

How to rename the Measure Names field in Tableau?

ARight Click on Measure Names, and select Rename

BRename the field from the Data Source page

CRename the field from the Metadata grid

DNone of the above

Answer : D

Measure Names is Tableau generated field, so you cannot rename it.

Question 7

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:

Tableau Desktop Certified Associate Exam Practice Test