[Jun-2026] Verified Salesforce Analytics-DA-201 Bundle Real Exam Dumps PDF
Analytics-DA-201 Dumps PDF New [2026] Ultimate Study Guide
NEW QUESTION # 102
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?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION # 103
A Data Analyst needs to calculate the percent of regional sales that each state contributes to. As a first step, the analyst needs to calculate total sales per region.
Which calculation should the analyst use to do this?
- A. {FIXED [State]: SUM([Sales])}
- B. {FIXED [State], [Region]: SUM([Sales])}
- C. [FIXED [Region]: TOTAL([Sales])]
- D. {FIXED [Region]: SUM([Sales])}
Answer: D
NEW QUESTION # 104
You have a data source that contains the following columns.
You have the following view that shows the percentage of total sales by category:
You want to change the calculation to show the percentage of total sales within the categories of every region annually. Which Compute Using option should you use? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
Explanation:
NEW QUESTION # 105
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
- A. {FIXED: TOTAL (Sales)}
- B. {FIXED: SUM Sales}
- C. {FIXED: [Region] SUM Sales}
- D. {Fixed: [Region]: TOTAL Sales}
Answer: B
Explanation:
The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be
{SUM(Sales)}. The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL
NEW QUESTION # 106
You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to include a number with the position of each state within each region?
- A. INDEX ()
- B. LOOKUP (SUM ([Quantity]))
- C. WINDOW_SUM(SUM ([Quantity]))
- D. FIRST ()
Answer: B
Explanation:
The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to include a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position. References: The information is inferred from general Tableau knowledge as well as the following sources:
* Tableau Functions (Alphabetical)
* LOOKUP
* Tableau Certified Data Analyst Exam Guide
NEW QUESTION # 107
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?
- A. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
- B. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
- C. Add both sheets to the dashboard. Set Fit to Fix width.
- D. Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
Answer: B
Explanation:
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
NEW QUESTION # 108
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To filter the table to show the Top 10 NOC based on the number of medals won, 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 NOC, discipline, and medals for each country.
* Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
* Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
* Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
* Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
* Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current
/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 109
A Data Analyst has a website that displays data in a table format.
The analyst wants to connect to the data of the website by using the least amount of effort.
What should the analyst use to connect to the data?
- A. CSV file
- B. Web data connector
- C. Clipboard
- D. ODBC connector
Answer: C
NEW QUESTION # 110
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?
- A. Cast
- B. Central
- C. South
- D. West
Answer: C
Explanation:
The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.
NEW QUESTION # 111
A Data Analyst is given the following table and asked to create a flow that adds a date field to the data. This field should automatically update as new dates (months) are added to the original table.
Which technique should the analyst use as the first step to achieve this in Tableau Prep?
- A. A Rows to Columns Pivot step
- B. An Aggregate step to reshape the data
- C. A wildcard search for multiple tables in the Input step
- D. A wildcard search to pivot in the Pivot step
Answer: D
NEW QUESTION # 112
You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00.
You need to ensure that the extract also refreshes on the last day of the month at 18:00.
What should you do?
- A. From Tableau Server, select Schedules, and change the priority of the existing schedule.
- B. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
- C. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
- D. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
Answer: C
Explanation:
To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes"
* Tableau Help: Refresh Data on a Schedule
* Tableau Help: Manage Refresh Tasks
NEW QUESTION # 113
A Data Analyst has the following dashboard.
Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?
- A. Select Remove Dashboard Item from the drop-down menu of Sales over time.
- B. Select Ignore Actions from the drop-down menu of Sales over time.
- C. Select Deselect from the drop-down menu of Sales over time.
- D. Deselect Use as Filter from drop-down menu of Profits by State
Answer: B
NEW QUESTION # 114
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.
- A. Tables
- B. Copiers
- C. Machines
G Phones - D. Furnishings
- E. Bookcases
- F. Chairs
- G. Accessories
Answer: A,C,G
Explanation:
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.
NEW QUESTION # 115
You have the following data source in tableau Server.
You need to ensure that the data is updated every hour.
What should you select?
- A. Connections
- B. New
- C. Extract Refreshes
- D. Connected Workbooks
Answer: C
Explanation:
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.
NEW QUESTION # 116
You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?
- A. Add a tooltip
- B. Drag the growth rate to Text on the Marks card
- C. Annotate March 2020
- D. Enable captions
Answer: C
Explanation:
To add a comment to March 2020 on a line chart, you need to annotate that mark. You can right-click on the mark and select Annotate > Mark from the menu. This will open a dialog box where you can type your comment and format it as you like. You can also drag and drop the annotation to position it on the worksheet.
Dragging the growth rate to Text on the Marks card will add a label to every mark on the line chart, enabling captions will show a description of the worksheet at the bottom, and adding a tooltip will show a text box when users hover over a mark. References: https://help.tableau.com/current/pro/desktop/en-us
/formatting_annotations.htm https://help.tableau.com/current/pro/desktop/en-us
/formatting_annotations_create.htm
To add a comment to a specific point on a line chart, such as March 2020 in the provided visualization, you would use the 'Annotate' feature. Right-clicking on the data point for March 2020 and selecting 'Annotate' allows you to add a text annotation directly to the chart, which can be used to highlight and comment on that particular data point.
NEW QUESTION # 117
Which option must a Data Analyst enable to build the following table to add quarterly totals?
- A. Add All Subtotals
- B. Show Row Grand Totals
- C. Add Pane Totals
- D. Show Column Grand Totals
Answer: A
NEW QUESTION # 118
You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.
- A. The data source must be stored as a hyper file.
- B. The data source must use a live connection.
- C. The credentials must be embedded.
- D. The data must be extracted.
Answer: C,D
Explanation:
To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a schedule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes"
* Tableau Help: Embedding Database Credentials
* Tableau Help: Extract Your Data
NEW QUESTION # 119
A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?
- A. Sales.hyper
- B. Book1.twb
- C. Sales.csv
- D. Export mdb
Answer: A
Explanation:
A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References: https://help.
tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com
/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us
/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-
9a3c-4a0b-8e6c-6d1f1f7c2b7e
In Tableau, a .hyper file is an extract file created by the Hyper database engine. It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.
NEW QUESTION # 120
A Data Analyst wants to create the following table in a view:
Which function should the analyst use to create the Position column?
- A. INDEX
- B. LAST
- C. FIRST
- D. RANK
Answer: C
NEW QUESTION # 121
A colleague provides a Data Analyst with access to a folder that has the following files:
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
- A. Export.mdb
- B. Sales.csv
- C. Sales.tds
- D. Book1.json
Answer: B
NEW QUESTION # 122
......
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
Pass Your Salesforce Exam with Analytics-DA-201 Exam Dumps: https://realtest.free4torrent.com/Analytics-DA-201-valid-dumps-torrent.html