ExamGecko
Home Home / Tableau / Desktop Certified Associate

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

Question list
Search
Search

Related questions











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.

A.
78.56
A.
78.56
Answers
B.
78.286
B.
78.286
Answers
C.
78.03
C.
78.03
Answers
D.
78.303
D.
78.303
Answers
Suggested answer: B

Explanation:

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:

How to rename the Measure Names field in Tableau?

A.
Right Click on Measure Names, and select Rename
A.
Right Click on Measure Names, and select Rename
Answers
B.
Rename the field from the Data Source page
B.
Rename the field from the Data Source page
Answers
C.
Rename the field from the Metadata grid
C.
Rename the field from the Metadata grid
Answers
D.
None of the above
D.
None of the above
Answers
Suggested answer: D

Explanation:

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

Groups can be used in a calculated field.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

Group can be used in a calculated field

Using the Sales Analysis Dashboard, create a filter action that will trigger once you select any state in Sales by State View, and it should update the Profit Vs Sales view. Find out using trend lines in the Profit Vs Sales view, how much does profit increase for each dollar of sales for the California state?

A.
0.180067
A.
0.180067
Answers
B.
0.133134
B.
0.133134
Answers
C.
0.294316
C.
0.294316
Answers
D.
0.167531
D.
0.167531
Answers
Suggested answer: B

Explanation:

Go to the Dashboard menu -> Actions -> Add Action -> Filter

Configure the properties as:

Ensure that West Region should be selected in the Region filter.

The final view should be:

profit increase by 0.133134 for each dollar of sales for the California state

Using the Sales Analysis Dashboard, If you click on any of the products, it should navigate to the All Products worksheet. How you will accomplish it?

A.
Go to Dashboard->Actions and create the go to URL action
A.
Go to Dashboard->Actions and create the go to URL action
Answers
B.
Go to Dashboard->Actions and create the go to sheet action
B.
Go to Dashboard->Actions and create the go to sheet action
Answers
C.
Go to Dashboard->Actions and create the Highlight action
C.
Go to Dashboard->Actions and create the Highlight action
Answers
D.
Right-click on the view, go to format, and provide the URL.
D.
Right-click on the view, go to format, and provide the URL.
Answers
Suggested answer: D

Explanation:

Go to Dashboard->Actions and create the go to sheet action

Which of the following are the valid dashboard actions in Tableau?

A.
URL action
A.
URL action
Answers
B.
Filter action
B.
Filter action
Answers
C.
Hover action
C.
Hover action
Answers
D.
Select action
D.
Select action
Answers
Suggested answer: A, B

Explanation:

Extract can't be created in which of the scenario?

A.
When you perform cross-database joins
A.
When you perform cross-database joins
Answers
B.
When you perform the blend
B.
When you perform the blend
Answers
C.
When you perform the union
C.
When you perform the union
Answers
D.
When you perform the traditional join
D.
When you perform the traditional join
Answers
Suggested answer: B

Explanation:

A blend is worksheet-specific, so you cannot create the extract while creating a blend.

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?

A.
Tables
A.
Tables
Answers
B.
Paper
B.
Paper
Answers
C.
Labels
C.
Labels
Answers
D.
Copiers
D.
Copiers
Answers
Suggested answer: A, C, D

Explanation:

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.

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?

A.
Appliances
A.
Appliances
Answers
B.
Binders
B.
Binders
Answers
C.
Storage
C.
Storage
Answers
D.
Tables
D.
Tables
Answers
Suggested answer: B

Explanation:

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.

Connect to the 'Covid data' source. What is the percentage increase in the new cases from July 2020 to Jan 2021?

A.
118.50%
A.
118.50%
Answers
B.
125%
B.
125%
Answers
C.
113.50%
C.
113.50%
Answers
D.
98%
D.
98%
Answers
Suggested answer: C

Explanation:

Create a filter on date field and select only July 2020 and Jan 2021.

Drop Date Month Discrete to Columns and New cases to the Text.

Right-Click on New Cases field and Quick Table Calc ->Percent Difference

Total 108 questions
Go to page: of 11