Free Preparation Discussions
MENU
Salesforce Analytics-DA-201 Exam Questions
- Topic 1: Connect To and Transform Data: This domain focuses on connecting to various data sources such as files, databases, and published sources, while deciding between live and extract connections. It also covers preparing, cleaning, transforming, and organizing data using Tableau features and Tableau Prep to ensure it is ready for accurate analysis.
- Topic 2: Explore and Analyze Data: This section covers creating calculations, applying filters, parameters, and structuring data to explore insights effectively. It also includes advanced analysis techniques such as table calculations, LOD expressions, forecasting, and geographic mapping to derive meaningful patterns and trends.
- Topic 3: Create Content: This domain involves building visualizations like charts, dashboards, and stories to present data insights clearly. It also focuses on adding interactivity, formatting, and designing responsive dashboards to enhance user experience and data communication.
- Topic 4: Publish and Manage Content on Tableau Server and Tableau Cloud: This section covers publishing workbooks, data sources, and flows to Tableau Server or Cloud for sharing and collaboration. It also includes managing content through scheduling refreshes, setting permissions, and creating alerts, subscriptions, and custom views.
Free Salesforce Analytics-DA-201 Exam Actual Questions
Note: Premium Questions for Analytics-DA-201 were last updated On May. 16, 2026 (see below)
A Data Analyst needs to analyze the financial performance of the sales team. In order to make the dashboards easier to understand, the analyst needs to format the financial values to show the dollar symbol ($) in front of the value.
How should the analyst enable this formatting across the workbook?
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?
You have the following: Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] - 1.
For which three the sub-categories will the value of Rank change? Choose three.
In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1). Therefore, its rank remains the same.
Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.
Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2. Therefore, its rank remains the same.
Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.
SIMULATION
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.
To filter the table to show the members of the Top10 set and the Bottom10 set, 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 Disciplines worksheet.
Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.
Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.
Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.
Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.
Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.
You have the following data source in tableau Server.
You need to ensure that the data is updated every hour.
What should you select?
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. Reference: 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.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Gerald Garcia
9 days agoBrenda Stewart
21 days agoRachel Baker
12 days agoJason Martin
6 days agoThomas Collins
2 days agoMirta
1 month agoAnnice
2 months agoCandra
2 months agoJennie
2 months agoEmogene
2 months agoNa
3 months agoSherron
3 months agoGlory
3 months agoGregoria
3 months agoJose
4 months agoToshia
4 months agoTammi
4 months agoTanja
4 months agoRosio
5 months agoRebbecca
5 months agoLizette
5 months agoLazaro
5 months agoJesusa
6 months agoElvera
6 months agoEsteban
6 months agoIsabelle
6 months agoKeena
7 months agoKanisha
7 months agoFlorinda
7 months agoAvery
7 months agoVal
8 months agoAlishia
8 months agoAmos
8 months agoTamar
8 months ago