ExamGecko
Home / Tableau / Desktop Certified Associate / List of questions
Ask Question

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

List of questions

Question 11

Report
Export
Collapse

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.

78.56
78.56
78.286
78.286
78.03
78.03
78.303
78.303
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.

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

Use the data Interpreter, it will correct the data.

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

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

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

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

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

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

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

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

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

Select Country and Country Name field, Merge these fields.

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

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.

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

Update the values as:

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

Result is:

Tableau Desktop Certified Associate image Question 11 explanation 75941 09232024004713000000

asked 23/09/2024
Paul Walker
41 questions

Question 12

Report
Export
Collapse

How to rename the Measure Names field in Tableau?

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

Explanation:

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

asked 23/09/2024
Alexander Voronetsky
42 questions

Question 13

Report
Export
Collapse

Groups can be used in a calculated field.

True
True
False
False
Suggested answer: A

Explanation:

Group can be used in a calculated field

Tableau Desktop Certified Associate image Question 13 explanation 75943 09232024004713000000

asked 23/09/2024
Andrea Chichiarelli
39 questions

Question 14

Report
Export
Collapse

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?

0.180067
0.180067
0.133134
0.133134
0.294316
0.294316
0.167531
0.167531
Suggested answer: B

Explanation:

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

Configure the properties as:

Tableau Desktop Certified Associate image Question 14 explanation 75944 09232024004713000000

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

The final view should be:

Tableau Desktop Certified Associate image Question 14 explanation 75944 09232024004713000000

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

asked 23/09/2024
Javier Rodriguez
33 questions

Question 15

Report
Export
Collapse

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?

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

Explanation:

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

Tableau Desktop Certified Associate image Question 15 explanation 75945 09232024004713000000

asked 23/09/2024
thanh nguyen
42 questions

Question 16

Report
Export
Collapse

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

URL action
URL action
Filter action
Filter action
Hover action
Hover action
Select action
Select action
Suggested answer: A, B

Explanation:

Tableau Desktop Certified Associate image Question 16 explanation 75946 09232024004713000000

asked 23/09/2024
Paul A
38 questions

Question 17

Report
Export
Collapse

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

When you perform cross-database joins
When you perform cross-database joins
When you perform the blend
When you perform the blend
When you perform the union
When you perform the union
When you perform the traditional join
When you perform the traditional join
Suggested answer: B

Explanation:

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

asked 23/09/2024
chris bezuidenhout
35 questions

Question 18

Report
Export
Collapse

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?

Tables
Tables
Paper
Paper
Labels
Labels
Copiers
Copiers
Suggested answer: A, C, D

Explanation:

Tableau Desktop Certified Associate image Question 18 explanation 75948 09232024004713000000

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.

Tableau Desktop Certified Associate image Question 18 explanation 75948 09232024004713000000

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

Tableau Desktop Certified Associate image Question 18 explanation 75948 09232024004713000000

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

Tableau Desktop Certified Associate image Question 18 explanation 75948 09232024004713000000

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

Tableau Desktop Certified Associate image Question 18 explanation 75948 09232024004713000000

asked 23/09/2024
Mustapha Amine Atmani
46 questions

Question 19

Report
Export
Collapse

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?

Appliances
Appliances
Binders
Binders
Storage
Storage
Tables
Tables
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:

Tableau Desktop Certified Associate image Question 19 explanation 75949 09232024004713000000

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.

Tableau Desktop Certified Associate image Question 19 explanation 75949 09232024004713000000

asked 23/09/2024
Shahir Kazmi
42 questions

Question 20

Report
Export
Collapse

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

118.50%
118.50%
125%
125%
113.50%
113.50%
98%
98%
Suggested answer: C

Explanation:

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

Tableau Desktop Certified Associate image Question 20 explanation 75950 09232024004713000000

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

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

Tableau Desktop Certified Associate image Question 20 explanation 75950 09232024004713000000

Tableau Desktop Certified Associate image Question 20 explanation 75950 09232024004713000000

asked 23/09/2024
David Hartnett
41 questions
Total 108 questions
Go to page: of 11