PDF (New 2026) Actual Salesforce Analytics-DA-201 Exam Questions [Q102-Q117]

admin
March 17, 2026

PDF (New 2026) Actual Salesforce Analytics-DA-201 Exam Questions [Q102-Q117]

5/5 - (1 vote)

PDF (New 2026) Actual Salesforce Analytics-DA-201 Exam Questions

Dumps Moneyack Guarantee – Analytics-DA-201 Dumps UpTo 90% Off

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. You have the following dashboard.

From the context menu of Sales over time, select Ignore Actions.
Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map.
What should you do?

From the context menu of Sales over lime, select Filters and then select Enable Auto Update.

From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.

From the context menu of Detail table, select Ignore Actions.

From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter

Q104. You have the following data source in tableau Server.

You need to ensure that the data is updated every hour.
What should you select?

New

Extract Refreshes

Connected Workbooks

Connections

To ensure that the data is updated every hour, you need to select Extract Refreshes from the data source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an existing one. You can specify the frequency and time of the refresh, as well as any custom options or credentials. New will create a new data source, Connected Workbooks will show you which workbooks use this data source, and Connections will show you which tables or files are connected to this data source. References: https://help.
tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us
/refresh_extracts_add.htm
To ensure that the data is updated every hour on Tableau Server, you would need to go to the “Extract Refreshes” option. Here, you can schedule the data extracts to refresh at the desired frequency, which in this case would be every hour.

Q105. 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

Q106. You want to create the following dashboard.

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.

Add both sheets to the dashboard. Set Fit to Fix width.

Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.

Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.

To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. References:
* Size and Lay Out Your Dashboard – Tableau
* Create a Dashboard – Tableau
* Format Dashboard Layout in Tableau – GeeksforGeeks

Q107. You have the following dataset.

Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?

Explanation:
To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every
[Category], which means that the ranking will reset for each category. References: https://help.tableau.com
/current/pro/desktop/en-us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro
/desktop/en-us/calculations_calculatedfields_lod_rank.htm

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

Explanation:
Sales: B. Columns
Profit: D. Rows
Customer Name: C. Detail on the Marks card
Category: A. Color on the Marks card
To create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm
https://help.tableau.com/current/pro/desktop/en-us/buildexamples_scatter.htm

Q109. Which attributes are required for the field that is used to hide or show an object with Dynamic Zone Visibility?

Boolean, Parameter, Single Value

Boolean, Single Value, Independent of the viz

String, Fixed Level of Detail (LOD), Dependent on the viz

Single Value, Integer, Independent of the viz

Q110. You have the following dataset.

You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?

NAMEUSERNAME()

ISFULLNAMETableu_USER_NAME))=USERNAME()

NAME Tableau-USER-NAME)

USERNAME()=(Tableau_USER_NAME)

To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.
The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau.
ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. ‘S’ + STR([Sales]
/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of
“S”. References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.
tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.
com/current/pro/desktop/en-us/calculations_calculatedfields.htm
In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset. Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME], which will return true for rows where the Tableau_User_Name matches the current user’s username.

Q111. Which option must a Data Analyst enable to build the following table to add quarterly totals?

Add All Subtotals

Show Column Grand Totals

Show Row Grand Totals

Add Pane Totals

Q112. You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?

From the Server menu, select Tableau Public, and then select Save to Tableau Public.

From the File menu, select Export Packaged Workbook.

From the Server menu, select Publish Data Source.

From the Server menu, select Publish Workbook.

To make a workbook available in Tableau Online, you need to publish it from Tableau Desktop to Tableau Online. You can do this by selecting Publish Workbook from the Server menu, signing in to your Tableau Online account, choosing a project and a name for your workbook, and clicking Publish. This will upload your workbook and its data sources to Tableau Online, where you can view, edit, and share it with others. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 10, section “Publishing and Scheduling Data Refreshes”
* Tableau Help: Publish a Workbook

Q113. A Data Analyst has the following dataset:

The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)

IF [Subject] = ‘Science’ THEN ‘Sciences’
ELSEIF [Subject] = ‘English’ THEN ‘Humanities’
ELSEIF [Subject] = ‘Social Studies’ THEN ‘Humanities’
ELSEIF [Subject] = ‘Computer Science’ THEN ‘Sciences’
END

IIF((CONTAINS([Subject], ‘Science’) = TRUE), ‘Humanities’, ‘Sciences’)

IF ENDSWITH([Subject], ‘Computer Science’) THEN ‘Sciences’ ELSE ‘Humanities’ END

CASE [Subject]
WHEN ‘Computer Science’ THEN ‘Sciences’
WHEN ‘English’ THEN ‘Humanities’
WHEN ‘Social Studies’ THEN ‘Humanities’
END

Q114. A Data Analyst has a dataset that contains the fallowing rows of sales data.

The analyst needs to return a value of TRUE if a month has sales greater than $50,000; otherwise, the formula must return a value of FALSE.
Which two formulas achieve this goal? (Choose two.)

SUM([Sales]) IN (50000)

[Sales] > 50000

MAX([Sales], 50000)

IF [Sales] > 50000 THEN TRUE ELSE FALSE END

Q115. You are subscribed to several views.
You need to unsubscribe from the views.
What should you use?

The My Content area of Tableau web pages

The Notifications area of Tableau Prep

The Data Source page of Tableau Desktop

The Shared with Me page

To unsubscribe from the views, you should use the My Content area of Tableau web pages. This area allows you to manage your subscriptions, as well as your workbooks, views, and data sources. You can select the views you want to unsubscribe from, click Actions, and then click Unsubscribe. You can also change the subscription options, such as the schedule, the format, or the message. References:
* Create a Subscription to a View or Workbook – Tableau
* Tableau Certified Data Analyst Study Guide

Q116. 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.

check the steps below in explanation.
Explanation:
To add the Sales by State sheet in a Show/Hide button to the right side of the dashboard, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the sales dashboard.
* Click on the sales dashboard tab at the bottom of the workbook to open the dashboard. You will see a dashboard that shows various charts and filters related to sales data.
* Drag Sales by State from the Sheets pane to the right side of the dashboard. This will add the sheet as a floating element on the dashboard. You can resize and position it as you like.
* Right-click on Sales by State and select Add Show/Hide Button from the menu. This will add a button that allows you to show or hide the sheet on the dashboard. You can customize the appearance and behavior of the button by clicking on it and using the options on the Marks card.
* Optionally, you can drag a vertical layout container from the Objects pane to the right side of the dashboard and place Sales by State and its button inside it. This will help you organize your dashboard elements and align them neatly.
References: https://help.tableau.com/current/pro/desktop/en-us/dashboards.htm https://help.tableau.com
/current/pro/desktop/en-us/dashboards_showhide.htm https://help.tableau.com/current/pro/desktop/en-us
/dashboards_create_layouts.htm

Q117. You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.
You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.
What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.

Change the data source to an extract before you publish.

Embed the credentials when you publish the workbook.

Remove all the data source filters before you publish.

Export the data to a .csv before you publish.

Configure the local file permissions to the workbook file, and then publish the workbook.

Loading …