[Dec-2025] Latest Salesforce Analytics-DA-201 Certification Practice Test Questions [Q101-Q123]

Q101. You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

Q102. You have the following two tables.

Table A is the primary table.
Which type of join is established when a blend is created by using the join key of Category?

Left join

Right join

Inner join

Outer join

Q103. Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.

Q104. You have the following dashboard.

When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

Q105. A Data Analyst needs to update an existing dashboard. The current dashboard shows financial results data, and users have asked for a comparison of budgets to be added to the dashboard. A new data source has been created that includes both the actual costs and budgets and was published to the corporate Tableau site.
How should the analyst update the existing dashboard?

Create a copy of the existing workbook, open it in Tableau Desktop, and connect to the new data source. Update each sheet, using fields from the new data source.

Edit the existing workbook on the Tableau site and connect to the new data source. Blend the new data source with the existing data source.

Create a new workbook in Tableau Desktop and connect to the new data source. Copy and paste all the tabs from the old workbook into the new one.

Edit the existing workbook on the Tableau site and connect to the new data source. From the Data menu, choose Replace Data Source.

Q106. You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

South

Cast

Central

West

Q107. You want to ensure that when you click a bar on a dashboard, a tooltip appears that contains a link named
“Click here to know more!” as shown in the following exhibit.

Q108. You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
* Top N Customers
* Customers of 2020
* Top N Products
* Sellers of 2020
Which two sets can you combine? Choose two

Sellers of 2020

Customers of 2020

Top N Products

Top N Customers

Q109. You have the following dataset.
You need to create the following worksheet.
The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

Q110. You have the following map.

You need the map to appear as shown in the following visualization.
What should you do?

Change the mark type to Density

Drag Location to Size on the Marks card

Change the mark type to Map

Drag Population to Size on the Marks card

Change the opacity to 75%

The question presents a scenario where a geographic map visualization in Tableau needs to be transformed from a series of discrete circles representing data points to a density map visualization. The density map shows concentrations of data points with a gradient of color, where denser areas are indicated by a darker color.
Here’s the explanation for each option:
A). Change the mark type to Density: This is the correct answer because changing the mark type to ‘Density’ in Tableau creates a density map, which displays the concentration of data points with a color gradient. This is exactly what is needed to achieve the visual effect shown in the second image, where regions with a higher concentration of data points are represented by darker shades.
B). Drag Location to Size on the Marks card: This option would adjust the size of the marks based on the number of locations, which is not relevant to creating a density map. It would result in varying sizes of circles, not a continuous gradient.
C). Change the mark type to Map: The visualization is already using a map. This option would not change the visualization to the desired density map.
D). Drag Population to Size on the Marks card: This would change the size of the circles based on the population values, making some circles larger and others smaller. This is not how a density map is created, which uses color intensity rather than size to show concentration.
E). Change the opacity to 75%: Changing the opacity would affect the transparency of the marks on the map but would not transform the visualization into a density map.
To achieve the visualization shown in the second image, the mark type must be changed to ‘Density,’ which will produce a heat map-like effect where the color intensity represents the concentration of data points.
Therefore, the correct answer is A. Change the mark type to Density.
To create a density map from a scatter plot of data points, you would change the mark type to Density. This mark type allows you to visualize the concentration of data points in an area, which can be useful for identifying clusters or patterns in geospatial data.

Q111. You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.
What should you do?

Right-click Sheet2 and select Add to Dashboard.

Select Sheet3 and click the Swap Sheet button next to Sheet2.

From the context menu of Sheet3. select Remove Dashboard item

Drag Sheet2 to the dashboard.

From the context menu of Sheet3. select Deselect

Q112. You have a dashboard that is configured for desktop browsers.
You want to customize a layout for mobile users.
Which option should you select first? (Click the appropriate Option in the Answer Area.)

Q113. You have the following dashboard that contains two visualizations.

You want to show only one visualization at time. Users must be able to switch between visualizations.
What should you me?

A parameter and a calculated filed

Worksheet actions

Show/hide buttons

Dashboard actions

Q114. You have a dashboard that contains a parameter named Start Date.
You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.
What should you do?

Create a data source based on the Excel worksheet and create a calculated field based on Start Date.
Add the calculated field to the extract filter.

Create a custom SOL query to define the data source and create a calculated field based on Start Date.
Add the calculated field to the extract filter.

Create a custom SOL query that references Stan Date in the WHERE clause.

Create a data source based on the Excel worksheet and create a calculated field based on Start Date.From the Data pane, add the calculated field to the data source filter

Q115. You have the following chart that shows profits and discounts over time.

You need to combine the lines to appear as shown in the following chart.

What should you do?

Drag Discount to Color on the Marks card

Convert Discount to Discrete

Set Discount to Dual Axis

Drag Discount to the Columns shelf

Q116. You have the following dataset:

Which grouping option should you use in Tableau Prep to group all five names automatically?

Pronunciation

Spelling

Manual Selection

Common Characters

Q117. A Data Analyst has a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.

The analyst wants to ensure that every calculation is affected by including only animals of a particular type.
Which type of filter should the analyst create on the worksheet?

Extract

Table calculation

Context

Measure

Q118. A colleague provides a Data Analyst with access to a folder that contains the following files:
Sales.csv
Book1.twb
Sales.hyper
Export.mdb
Which file is a Tableau extract?

Sales.hyper

Sales.csv

Export.mdb

Book1.twb

Q119. A Data Analyst has the following chart.

The analyst needs to enable the drilldown from Category to Subcategory as shown in the following chart.

What should the analyst create?

A bin for Category and a bin for Subcategory

A hierarchy of Category and Subcategory

A combined set for Category and Subcategory

A group of Category and Subcategory

Q120. You plan to create a Tableau subscription for several users.
Which two formats can you use? Choose two.

PDF

Image

Microsoft Excel

Microsoft PowerPoint

Q121. A Data Analyst has a data source that contains the following columns:

he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?

Drag the LOD expression to the Filters shelf.

Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.

Right-click the State dimension filter, and then click Attribute.

Right-click the State dimension filter, and then click Add to Context.

Q122. You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?

COVAR({Award})

COUNTD({Award})

COUNTD {(NAME])

MAX {(Award})

INDEX()

Q123. You create the following story that contains two story point.

You want to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should you use?

Dots

Arrows only

Caption boxes

Numbers

Leave a Reply Cancel reply