Tableau Desktop-Certified-Associate Exam Practice Test Instant Access

Question 1

In LOD calculation, we can use fields from multiple data sources (blended data source)?

ATrue

BFalse

Answer : B

Here, the Location is in a primary data source, and the population field is in a secondary data source.

So the answer is FALSE.

Question 2

Groups can be used in a calculated field.

ATrue

BFalse

Answer : A

Group can be used in a calculated field

Question 3

Connect to the "Kiva Loans - India" data source, find out which sector has the highest distribution of loan amount using interquartile ranges?

AEducation

BEntertainment

CRetail

DWholesale

Answer : D

Create a box plot using Sector and Loan amount.

The IQR is maximum for the Wholesale sector.

Question 4

I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we don't need. For example - We don't have any country which is part of the Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it?

Larger image

AYou will select Exclude Values in a filter card options

BYou will select Only Relevant Values in a filter card options

CYou will select Format filter and Set Control in a filter card options

DYou will select Wild card match in a filter card options

Answer : B

Go to Filter card options, and Select Only Relevant values

Question 5

Connect to the "Kiva Loans - India" data source, create a chart using the continuous disbursed month (Disbursed Time field) and sum of the loan amount, exclude the null values. What is the skewness of this chart?

A.42

B.51

C.48

D.55

Answer : A

Enable the Summary Card from Show/Hide menu as shown:

Skewness is .42

Question 6

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 7

Connect to the "Global Superstore" data source and use the Orders table. Create a bar in bar chart and compare the profit against the target profit for Canada Region. Consider target profit is 30% of the sales. Which of the following sub-categories has met or exceed the target profit?

ATables

BPaper

CLabels

DCopiers

Answer : A, C, D

Drop Region at the filter and Select Canada

Drop Profit to columns and Sub-Category to Rows

Then drop the target profit to profit axis, it will create the combined axis chart.

Now drop the Measure Names field from the Rows to the Color Marks Card.

Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will start from 0)

Tables, Labels and Copiers sub-categories has met or exceed the target profit.

Tableau Desktop-Certified-Associate Tableau Desktop Certified Associate Exam Practice Test