Real Exam Questions Analytics-DA-201 Dumps Exam Questions in here [Dec-2025]
Get Latest Dec-2025 Conduct effective penetration tests using Analytics-DA-201
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
NEW QUESTION # 56
You have the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
- A. (SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))
- B. (SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
- C. (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )
- D. (SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
Answer: B
Explanation:
The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter. References:
* LOOKUP Function - Tableau
* Table Calculations - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 57
You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
- A. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
- B. IF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END - C. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- D. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End
Answer: B,D
Explanation:
To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects. References:
* Logical Functions - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 58
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.)
Answer:
Explanation:
Explanation:
To customize a layout for mobile users, you should select the Device Preview option first. This option will allow you to see how your dashboard will look on different types of devices, such as phones, tablets, or desktops. You can also choose different models and orientations to preview different screen sizes and resolutions. From the Device Preview mode, you can add, edit, or delete device layouts for each device type.
You can also adjust the size, position, and formatting of the dashboard elements for each device layout. References:
* Create Dashboard Layouts for Different Device Types - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 59
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?
- A. Right-click the State dimension filter, and then click Attribute.
- B. Right-click the State dimension filter, and then click Add to Context.
- C. Drag the LOD expression to the Filters shelf.
- D. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
Answer: B
NEW QUESTION # 60
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.
You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?
- A. Right-click a bar in the chart select Mark Label and then select Always show.
- B. Right-click a in the chat, select Annotate and then select Mark.
- C. Edit the aliases for City.
- D. Drag Region to Tooltip on the Marks card
Answer: D
Explanation:
To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the 'Region' field to the 'Tooltip' shelf on the 'Marks' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.
NEW QUESTION # 61
A Data Analyst has a data source that contains data for every city in the United States. The following is a sample of the data.
The analyst needs to use the City dimension to create a dynamic filter that shows the cities that have a population greater than 1 million.
Which type of filter should the analyst use?
- A. Range
- B. Top
- C. Special
- D. Condition
Answer: D
NEW QUESTION # 62
A Data Analyst has created a Tableau Prep flow that is ready to be used. The output will be used by a colleague to build a dashboard on Tableau Cloud or Tableau Server.
Where should the analyst output the data to?
- A. A published data source
- B. CRM Analytics
- C. Salesforce Data Cloud
- D. A Tableau data extract file
Answer: A
NEW QUESTION # 63
You have the following primary data source that contains a dimension named Dorm_Code.
You receive the following secondary data source that contains updated dorm codes.
You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?
- A. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New
- B. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
- C. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window
- D. Bring in the secondary data source as a union.
Answer: A
Explanation:
* Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization.
https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view-based-on-dimension To update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace References allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.
NEW QUESTION # 64
A Data Analyst is creating an annual report in Microsoft Word.
In Tableau Desktop, the analyst built a chart in a worksheet.
The analyst wants to create an image of the chart to add to the annual report.
Which two options should the analyst use to create the image? (Choose two.)
- A. Export option from the Worksheet menu
- B. Copy option from the Worksheet menu
- C. Export Image option from the Dashboard menu
- D. Copy Image option from the Dashboard menu
- E. Export As Version option from the File menu
Answer: A,B
NEW QUESTION # 65
You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.
You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.
Which object should you add to the dashboard?
Answer:
Explanation:
The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation.
Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it.
You can learn more about navigation objects and how to use them in this article: https://help.tableau.com
/current/pro/desktop/en-us/dashboards_navigation.htm
NEW QUESTION # 66
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.
Answer:
Explanation:
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
NEW QUESTION # 67
You have the following Map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Change the mark type to Map.
- B. Change the mark type to Density.
- C. Drag Location to Size on the Marks card.
- D. Drag Population to Size on the Marks card.
- E. Change the opacity to 75%.
Answer: B
Explanation:
To create a map visualization that shows the concentration of data points in different locations, you need to change the mark type to Density. This will create a heatmap that uses color and size to indicate the density of the data points. You can also adjust the intensity and transparency of the density marks to suit your needs. References: The information is based on the following sources:
* Create Heatmaps that Show Trends or Density in Tableau
* Build a Simple Map - Tableau
NEW QUESTION # 68
You have the following dataset:
Which grouping option should you use in Tableau Prep to group all five names automatically?
- A. Common Characters
- B. Pronunciation
- C. Manual Selection
- D. Spelling
Answer: A
Explanation:
Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as "John Smith" and "Smith, John" because they both generate the key "hijmnost". Since this algorithm doesn't consider pronunciation, the value "Tom Jhinois" would have the same key "hijmnost" and would also be included in the group.
NEW QUESTION # 69
You are developing a data source in Tableau Prep.
You have two tables named Orders and Employees.
The Orders table was created in 2019 and contains the following columns.
The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns You want to prepare the data so that you can analyze sales trends over time for every sales team.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area. Use Answer Area arrows to re-order the options.)
Answer:
Explanation:
There are different ways to prepare the data in Tableau Prep, but one possible answer is:
Answer area:
* Join the tables.
* Aggregate the data by Sales Team.
* Add the following filter to the Employees table: Sale Team - Team Alpha.
To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.
References:
[Tableau Certified Data Analyst Exam Prep Guide], page 9, section "Preparing Data"
[Tableau Help: Join Your Data]
[Tableau Help: Aggregate Your Data]
[Tableau Help: Filter Your Data]
NEW QUESTION # 70
A Data Analyst creates the following story that contains two story points.
The analyst wants 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 the analyst use?
- A. Arrows only
- B. Caption boxes
- C. Numbers
- D. Dots
Answer: A
NEW QUESTION # 71
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.
Answer:
Explanation:
Explanation:
To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References:
* Build a Scatter Plot
* Understanding and Using Scatter Plots
* Scatter plot in Tableau
NEW QUESTION # 72
From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?
- A. All the data sources published to the site within the folders to which you have access
- B. All the data sources published to the Tableau Server within the folders to which you have access
- C. All the data sources published to the site
- D. All the data sources published to the Tableau Server
Answer: A
Explanation:
When you sign in to a Tableau Server site from Tableau Desktop and search for a published data source, you will see all the data sources published to the site within the folders to which you have access. You will not see data sources published to other sites or folders that you do not have permission to view. You can also filter your search by project, owner, or tag. References: https://help.tableau.com/current/pro/desktop/en-us
/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_tableauserver.htm When signed in to Tableau Server from Tableau Desktop, you'll only be able to see the data sources that have been published to the site and are within the folders that you have been granted access to. Tableau's permission and project structure mean that you won't see all data sources from the entire server unless you have permissions to do so.
NEW QUESTION # 73
......
Authentic Best resources for Analytics-DA-201 Online Practice Exam: https://www.testbraindump.com/Analytics-DA-201-exam-prep.html
Get the superior quality Analytics-DA-201 Dumps with explanations waiting just for you, get it now: https://drive.google.com/open?id=1Ig8vnQVPCfU7MsWHqaRWYxvwos00irGN
