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

Explanation:

Add the Country population excel sheet as a New Data Source.

Select column 1960 to 2013, click on Pivot.

Graphical user interface, application Description automatically generated

Rename the new fields as Year and population.

Go to Data ->Edit Blend Relationship

Click on Custom and Add

Graphical user interface, text, application Description automatically generated

Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.

Drop the year to the filters shelf and only enter 1963.

Graphical user interface Description automatically generated

Drop Country and Number of Records / volerup(Count) field to the view.

And drop population to the view from the secondary data source. Your view will look like this:

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

Explanation:

Click on the State/Province list, and select the State. So Tableau will recognize the city as part of the states in the Country/Region United States.

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.

Graphical user interface, application Description automatically generated

Use the data Interpreter, it will correct the data.

Graphical user interface, text, application Description automatically generated

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

Graphical user interface, text, application Description automatically generated

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

Graphical user interface, application Description automatically generated

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

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

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

A picture containing graphical user interface Description automatically generated

Select Country and Country Name field, Merge these fields.

Graphical user interface, application Description automatically generated

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.

Graphical user interface, application Description automatically generated

Update the values as:

Graphical user interface, application, Word Description automatically generated

Result is:

Graphical user interface, application, Word 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:

The first option is wrong here, you can turn on the highlighter only for the discrete fields in your view.

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

Explanation:

Create an inner join between Orders and Returns table using Order ID

Graphical user interface, application Description automatically generated

Create a calculated field to find the unique order.

Graphical user interface, text, application Description automatically generated

Drop Region, Ship Mode, and Category to Rows. And drop 'countd order' field to Text. The final view would look like this:

Graphical user interface, text, application Description automatically generated

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:

When you use a left join to combine tables, the result is a table that contains all values from the left table and corresponding matches from the right table.

Refer Join Types: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm

Explanation:

Drop the Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:

Graphical user interface, text, application Description automatically generated

Go to the Analytics tab and drop the Forecast to your view.

Right-Click on the view, Select Forecast -> Forecast Options. Change the Ignore last to 0 months,

Graphical user interface, text, application Description automatically generated

$35,152 is the correct answer.

Graphical user interface, chart, line chart Description automatically generated

Explanation:

Measures are by default aggregated. We can change measures to dimensions if we want disaggregate that field.

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