Verified Analytics-DA-201 dumps Q&As – 2026 Latest Analytics-DA-201 Download [Q87-Q105]

4/5 - (1 vote)

Verified Analytics-DA-201 dumps Q&As – 2026 Latest Analytics-DA-201 Download

Dumps Questions [2026] Pass for Analytics-DA-201 Exam

Salesforce Analytics-DA-201 Exam Syllabus Topics:

Topic	Details
Topic 1	Object-Oriented Design: This section of the exam evaluates the SAP ABAP Cloud Developer’s understanding of object-oriented principles in the ABAP context. It focuses on class-based programming, inheritance, interfaces, and polymorphism, all crucial for building modular and maintainable ABAP cloud applications.
Topic 2	ABAP Core Data Services and Data Modeling: This section of the exam measures the skills of the SAP ABAP Cloud Developer and covers the fundamental understanding of core data services (CDS) and how to design data models in the SAP ABAP environment. Candidates are expected to know how to define, consume, and optimize CDS views effectively to support application development in the cloud.
Topic 3	SAP Clean Core Extensibility and ABAP Cloud: This part of the exam targets the SAP S 4HANA Technical Consultant and covers concepts of clean core extensibility using ABAP in the cloud. The focus is on in-app and side-by-side extensibility techniques, ensuring that custom code complies with cloud-readiness principles and does not compromise the upgrade stability of core systems.
Topic 4	ABAP RESTful Application Programming Model: This section of the exam evaluates the capabilities of the SAP S 4HANA Technical Consultant in using the ABAP RESTful Application Programming Model (RAP). It focuses on understanding the structure and components of RAP, including behavior definitions, service bindings, and metadata extension. The goal is to validate the ability to develop modern and scalable applications using RAP.

Q87. A Data Analyst has the following worksheet, with Profit data for Categary and Sub-Categury.

The analyst executed the following calculated field at the Total level:
COUNTD( IF ( INCLUDE [Sub-Category]: SUM([Profit]) < 0 THEN [Category] END ) What is the result?

Q88. A Data Analyst has the following dataset.

The analyst wants to create a parameter to dynamically filter the data to produce the following results based on quantity being above X value.

Which two types of parameters should the analyst use to produce the results? (Choose two)

Integer

Boolean

Date

Float

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

Q90. You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

Pronunciation

Spelling

Common Characters

Manual Selection

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

Q92. You have a data source that contains the following columns.
You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
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.)

To filter regions based on the highest sales and allow users to specify the number of regions shown, you should perform these actions in order:
Answer area:
* Create an integer data type parameter named Param1.
* Drag Region to the Filters shelf.
* Configure a Top filter by field. Use Param1 and filter by the sum of Sales.
To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression.
In this question, you want to filter regions based on the highest sales. You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:
* First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right- clicking on the Data pane and selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values. You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value.
* Next, you need to drag Region to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.
* Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a filter expression that looks like this: Top Param1 by SUM(Sales).
By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the parameter value.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section “Filtering Data” Tableau Help: Parameters Tableau Help: Top Filters

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

Q94. You subscribe to a view that delivers a daily email to your inbox.
You want to make the subscription available to other stakeholders.
What should you do?

From the worksheet, modify the subscription.

From the My Content overview page, modify the subscription.

From the dashboard overview page, modify the subscription.

From the My Content overview page, modify the alert.

Q95. You have a table that contains four columns named Order Date, Country, Sales, and Profit.
You need to add a column that shows the day of the week for each row. For example, orders placed on August
31, 2022, will show a day of
Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Q96. You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

Image

Sheet

Web page

Horizontal

Q97. Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.

Q98. Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.

Q99. You have the following visualization.

You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Q100. A Data Analyst has a workbook that uses an extracted data source.
The analyst publishes the workbook to Tableau Server.
Which three actions can the analyst perform from the Extract Refresh page in Tableau Server? (Choose three.)

Run a refresh

Change the refresh from full to incremental

Delete the refresh

Modify the frequency of the refresh

Change the priority of the refresh

Q101. You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data”

Q102. You plan to publish a workbook to Tableau Server.
You want to ensure that users can see other published dashboards from their current dashboard.
Which setting should you configure? (Click the appropriate Option in the Answer Area.)

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

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

Q105. In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?

TRIM

CONTAINS

REPLACE

SPLIT