Desktop-Certified-Associate Tableau Desktop Certified Associate Exam Questions and Answers

Create the calculated field:

Drop the carrier name to the view and % of delayed flights to text.

We only have 2013 data, so filter won’t make a difference:

Explanation:

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

Graphical user interface, application Description automatically generated

Explanation:

Cube data sources can only be used as the primary data source for blending data in Tableau.

All others are true.

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

Explanation:

{ FIXED [Category] : SUM([Profit])} - It calculates the profit of each category. In our view, all the profits values are the same, so it is not the right answer.

{ FIXED [Region] : SUM([Profit])} - It calculates the profit of each region.

{SUM([Profit])} is equivalent to {FIXED : SUM([Profit])}. It is the table level scope, which means this is the profit of the entire dataset.

Explanation:

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

Configure the properties as:

Graphical user interface Description automatically generated

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

The final view should be:

Map Description automatically generated

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

Explanation:

Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.

Drop the City to the view, and add the State to the Filter shelf and select North Carolina.

Also, drop the Order Date to the Filters and select year 2012, 2013, 2014

Graphical user interface, text, application, email Description automatically generated

Now, drop the Profit field to the tooltip. As of now, your view should look like this:

A picture containing map Description automatically generated

Now, we have to find the total profit earned by all the cities in Wake County.

Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.

Graphical user interface, text, application, chat or text message Description automatically generated

To show the County go to the Map->Map Layers.

Check County Names and County Borders.

Graphical user interface, text, application Description automatically generated

the total profit earned by all the cities in Wake County is $403.

A picture containing map Description automatically generated

Explanation:

Group can be used in a calculated field

Graphical user interface, text, application Description automatically generated

Explanation:

First, find the distinct sports for each country:

Graphical user interface Description automatically generated with medium confidence

It will be created as a Measure, move this to Dimension

Get the distinct countries:

Graphical user interface Description automatically generated with medium confidence

drop these columns to the view, final view will look like this:

The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.

Chart Description automatically generated

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

Explanation:

Graphical user interface Description automatically generated

Explanation:

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

Explanation:

Left join the Orders and Returns table

Diagram Description automatically generated

Number of orders returned will be order ID from the returns table divide by total orders

Graphical user interface, text, application, website Description automatically generated

Drop the customer name and ret order field in the view.

Graphical user interface, text, application, chat or text message Description automatically generated

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation:

Go to the Map -> Map Layer

Cities Borders is not valid.

Graphical user interface, text, application, chat or text message Description automatically generated