Desktop-Certified-Associate Tableau Desktop Certified Associate Free Practice Exam Questions (2025 Updated)

Blend is the left outer join after aggregation at the level of granularity.

Custom geocoding means that you assign latitude and longitude coordinates toyour locations

so Tableau can plot them accurately.

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

If customer first order is equal to the order date, then this is the new customer.

Create a calculated field to find the first order date:

Find If the order date is equal to the day of first purchase for that customer, flag that row as a

'New Customer'

Find the unique customers:

Drop the Order date to filter shelf and select the year 2014 to find out the new customer

acquired in 2014.

Drop New Customer field to Rows and Unique customer field to Text marks card.

Drop the country field to the view and also to the filter and select Australia.

Drop the State to the detail marks card.

Create the Unique Customer field to the Label.

Your view will look like this:

Northern Territory has the minimum unique customers – 19.

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:

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

Go to the section- Phone layouts and the Default dashboard

Create the Calculated field ‘Math Performers’:

Drop the Math Performer field to the Rows and drop gender to filter, select ‘Men’

Drop the Number of Records (if tableau version prior to 2020.2) to the Text

Or

Drop the Education.csv(Count) (tableau version 2020.2 and after) to the Text

Apply ‘Percent of Total’ Quick table calculation to the field on the Text marks card:

Drop the Country field to the view.

Drop the Region to the filters shelf and select Europe & Central Asia.

Drop the GDP per capita to the label and change the aggregation to Avg.

Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.

Create a hierarchy using City-Airport Name-Carrier Name.

Filter using Ontime Category field and select the Ontime.

Drop the hierarchy to the view and Number of flights to the Text.

Check each combination from the answers:

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:

Graphical user interface Description automatically generated

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.

Explanation:

Create a hierarchy of Segment, Category, Region and drop it into the rows.

Text Description automatically generated

Create profit ratio calculated field:

Graphical user interface, text Description automatically generated

Drop the profit and profit ratio fields to the view, your view will look like this:

Graphical user interface, text, application Description automatically generated

Now let's go through each answer option.

1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.

2) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765 - It is true, the profit ratio is 2.06%, which is third-lowest.

3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.

4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False

Note: This is an easy question but time consuming, so attempt these types of questions in the end.

Explanation:

Drop Order Date to the Columns and change it to continuous month. Drop sales to the rows.

Go to Analytics and drop the trend line. Check for all trend lines, Linear is having the lowest R Square.

Chart, line chart Description automatically generated

Explanation:

Add year and location filter as:

Graphical user interface, application Description automatically generated

Graphical user interface, text, application Description automatically generated

Drop Name, year, month to the rows. Change year and month to discrete from continuous.

A picture containing chart Description automatically generated

So, 3 volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year.

You can also use the map view to get the results, here I added the month filter as well and drop the count of records to the text.

Map 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:

Automatically add phone layouts

Two options let you automatically add phone layouts:

To create phone layouts whenever you open old dashboards that lack them, choose Dashboard > Add Phone Layouts to Existing Dashboards

To create phone layouts whenever you create a new dashboard, choose Dashboard > Add Phone Layouts to New Dashboards. (This option is on by default.)

Refer: https://help.tableau.com/current/pro/desktop/en-us/dashboards_dsd_create.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