ExamGecko
Home Home / Tableau / Desktop Certified Associate

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

Question list
Search
Search

Related questions











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

Larger image

A.
Add the Columns Totals on Top from Analysis Menu
A.
Add the Columns Totals on Top from Analysis Menu
Answers
B.
Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
B.
Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
Answers
C.
Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
C.
Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
Answers
D.
Drop the measure to the color marks card
D.
Drop the measure to the color marks card
Answers
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.

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?

A.
United States
A.
United States
Answers
B.
Chile
B.
Chile
Answers
C.
Japan
C.
Japan
Answers
D.
Indonesia
D.
Indonesia
Answers
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.

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

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.

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

A.
The data to combine has the same structure but consists of data of different years.
A.
The data to combine has the same structure but consists of data of different years.
Answers
B.
The combined data will be used in many worksheets in the current workbook.
B.
The combined data will be used in many worksheets in the current workbook.
Answers
C.
The data to combine is at a different level of detail.
C.
The data to combine is at a different level of detail.
Answers
D.
All of the above.
D.
All of the above.
Answers
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.

How the ATTR() is defined in Tableau?

A.
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE '*' END
A.
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE '*' END
Answers
B.
IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE '*' END
B.
IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE '*' END
Answers
C.
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
C.
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
Answers
D.
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END
D.
IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END
Answers
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

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

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

Explanation:

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

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

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

Explanation:

Using Analytics pane:

Right Click on Axis and Add Reference Line:

When it is recommended to create multiple table extracts?

A.
If incremental refresh is configured
A.
If incremental refresh is configured
Answers
B.
If we are using extract filters to limit the data
B.
If we are using extract filters to limit the data
Answers
C.
If row-level security needs to be enforced
C.
If row-level security needs to be enforced
Answers
D.
None of the above
D.
None of the above
Answers
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

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?

A.
2012
A.
2012
Answers
B.
2013
B.
2013
Answers
C.
2014
C.
2014
Answers
D.
2015
D.
2015
Answers
Suggested answer: A

Explanation:

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

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

Update Total All Using to Average:

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

Which of the following is true about spatial files?

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

Explanation:

All are false here.

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

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

A.
Source Sheet
A.
Source Sheet
Answers
B.
Target Sheet
B.
Target Sheet
Answers
C.
Run action on
C.
Run action on
Answers
D.
Target filter on Selected fields
D.
Target filter on Selected fields
Answers
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.

Total 108 questions
Go to page: of 11