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

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

List of questions

Question 21

Report
Export
Collapse

To create this view, what all you have to do from the following options?

Larger image

Tableau Desktop Certified Associate image Question 21 75951 09232024004713000000

Add the Columns Totals on Top from Analysis Menu
Add the Columns Totals on Top from Analysis Menu
Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
Drop the measure to the color marks card
Drop the measure to the color marks card
Suggested answer: B, D

Explanation:

Option 1 - It is not valid, as we are not showing Columns Totals on Top.

Option 3 - It is not valid, as we are modifying the row divider settings and not the column divider settings.

Rest are true.

asked 23/09/2024
Antonio Carlos Figueiredo Junior
50 questions

Question 22

Report
Export
Collapse

Connect to the 'Significant Volcano Eruption' data source. Create a histogram using field Death and having a bin size of 500. Find out which country reported 9 deaths in the bin of 0-500?

United States
United States
Chile
Chile
Japan
Japan
Indonesia
Indonesia
Suggested answer: A

Explanation:

Select the measure "Death" and go to the Show Me and Click on Histogram

When we are binning the measure, it will create the dimension, so you get a new dimension as Death (bin). Right-click on this and click on Edit. Update the size of bins to 500.

Tableau Desktop Certified Associate image Question 22 explanation 75952 09232024004713000000

Drop the Country to the color, so our view will look like this:

Tableau Desktop Certified Associate image Question 22 explanation 75952 09232024004713000000

Now drop the Country to the filter and select 4 countries mentioned in our options.

Hover the bar, it shows the United States has reported 9 deaths.

Tableau Desktop Certified Associate image Question 22 explanation 75952 09232024004713000000

asked 23/09/2024
Vilfride Lutumba
41 questions

Question 23

Report
Export
Collapse

In which of the following scenarios you should use the blend?

The data to combine has the same structure but consists of data of different years.
The data to combine has the same structure but consists of data of different years.
The combined data will be used in many worksheets in the current workbook.
The combined data will be used in many worksheets in the current workbook.
The data to combine is at a different level of detail.
The data to combine is at a different level of detail.
All of the above.
All of the above.
Suggested answer: C

Explanation:

Union - The data to combine has the same structure but consists of data of different years.

Blend - The data to combine is at a different level of detail.

asked 23/09/2024
Dasaret Tillman
40 questions

Question 24

Report
Export
Collapse

How the ATTR() is defined in Tableau?

IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE '*' END
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE '*' END
IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE '*' END
IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE '*' END
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END
Suggested answer: A

Explanation:

IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE '*' END

Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function

asked 23/09/2024
metodija durtanoski
41 questions

Question 25

Report
Export
Collapse

To create a choropleth map, your data source should include the following types of information?

Quantitative or qualitative values
Quantitative or qualitative values
Location names or custom polygons
Location names or custom polygons
Background image
Background image
Custom Territories
Custom Territories
Suggested answer: A, B

Explanation:

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

asked 23/09/2024
Randhir Singh
37 questions

Question 26

Report
Export
Collapse

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

Using Analytics pane
Using Analytics pane
Using Data Pane
Using Data Pane
Using Analysis Menu
Using Analysis Menu
Right Click on Axis and Add Reference Line
Right Click on Axis and Add Reference Line
Suggested answer: A, D

Explanation:

Using Analytics pane:

Tableau Desktop Certified Associate image Question 26 explanation 75956 09232024004713000000

Right Click on Axis and Add Reference Line:

Tableau Desktop Certified Associate image Question 26 explanation 75956 09232024004713000000

asked 23/09/2024
Benjamin Colart
47 questions

Question 27

Report
Export
Collapse

When it is recommended to create multiple table extracts?

If incremental refresh is configured
If incremental refresh is configured
If we are using extract filters to limit the data
If we are using extract filters to limit the data
If row-level security needs to be enforced
If row-level security needs to be enforced
None of the above
None of the above
Suggested answer: C

Explanation:

It is recommended to create multiple table extracts when row-level security needs to be enforced.

Refer: https://www.tableau.com/about/blog/2018/10/you-can-now-choose-multiple-table-storage-extracts-94776

asked 23/09/2024
DAVID Durbin
37 questions

Question 28

Report
Export
Collapse

Connect to the 'Global Superstore' data source and use the Orders table. Find out in which year the furniture sales were more than the average sales of that year?

2012
2012
2013
2013
2014
2014
2015
2015
Suggested answer: A

Explanation:

Drop Order Date to columns, Category to Rows, and Sales to Text.

Go to Analysis -> Totals -> Show Columns Grand Total

Tableau Desktop Certified Associate image Question 28 explanation 75958 09232024004713000000

Update Total All Using to Average:

Tableau Desktop Certified Associate image Question 28 explanation 75958 09232024004713000000

Tableau Desktop Certified Associate image Question 28 explanation 75958 09232024004713000000

In the year 2012, the furniture sales were more than the average sales of that year.

asked 23/09/2024
Ahsan Ilyas
32 questions

Question 29

Report
Export
Collapse

Which of the following is true about spatial files?

You cannot create a dual-axis chart using spatial data
You cannot create a dual-axis chart using spatial data
You cannot join spatial data source with the non-spatial data source
You cannot join spatial data source with the non-spatial data source
You cannot apply filters in your view if it is creates using the spatial data source
You cannot apply filters in your view if it is creates using the spatial data source
None of the above
None of the above
Suggested answer: D

Explanation:

All are false here.

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

asked 23/09/2024
Mark Hughes
30 questions

Question 30

Report
Export
Collapse

When we create a filter action in a dashboard, what all we must specify so that it will work?

Source Sheet
Source Sheet
Target Sheet
Target Sheet
Run action on
Run action on
Target filter on Selected fields
Target filter on Selected fields
Suggested answer: A, B, C

Explanation:

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.

Tableau Desktop Certified Associate image Question 30 explanation 75960 09232024004713000000

asked 23/09/2024
Junwei Li
37 questions
Total 108 questions
Go to page: of 11