[Jun-2026] Tableau Data Analyst Analytics-DA-201 Exam Practice Dumps
2026 Analytics-DA-201 Premium Files Test pdf - Free Dumps Collection
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
NEW QUESTION # 19
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
* Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
* Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
* Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
* Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a
# sign next to it.
* Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
* Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm
NEW QUESTION # 20
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.)
Answer:
Explanation:
Explanation:
we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:
IF FIRST () = 0 THEN COUNT (Returns) END
This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.
To complete the formula in the calculated field, you should select the following options from the drop-down menus:
* FIRST ()
* 0
* COUNT (Returns)
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm
NEW QUESTION # 21
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 # 22
In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.
Which function should the analyst use to remove the trailing spaces from the Category field?
- A. LTRIM
- B. REPLACE
- C. SPLIT
- D. RTRIM
Answer: D
NEW QUESTION # 23
You want to create the following dashboard that will contain two sheets.
What should you do?
- A. Add a border to both sheets and add both sheets to a horizontal object.
- B. Drag both sheets to the dashboard and add a border to each sheet.
- C. Drag both sheets to the dashboard and add a background lo each sheet.
- D. Add both sheets lo a horizontal container and add a border to the container.
Answer: D
NEW QUESTION # 24
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. Dots
- B. Caption boxes
- C. Arrows only
- D. Numbers
Answer: C
NEW QUESTION # 25
You have the following dashboard.
Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table What should you do?
- A. From the context menu of Sales over time select Ignore Actions
- B. From the context menu of Profits by Stale deselect Use as Filter
- C. From the context menu of Sales over lime select Remove Dashboard Item
- D. From the context menu of Sales over time select Deselect
Answer: A
Explanation:
To configure the dashboard to ensure that selecting a data point on the map only filters the Detail table, you should select Ignore Actions from the context menu of Sales over time. Ignore Actions is a feature that allows you to exclude a sheet from being affected by any actions on the dashboard, such as filters or highlights. You can select Ignore Actions by right-clicking on a sheet on the dashboard and selecting Ignore Actions from the menu.
In this case, you want to exclude Sales over time from being filtered by the map, so you should select Ignore Actions from its context menu. This will make Sales over time ignore any selections on the map and show all values. The Detail table will still be filtered by the map as usual.
The other options are not correct for this scenario. Removing Dashboard Item will delete Sales over time from the dashboard, which is not what you want. Deselecting Use as Filter will disable the map as a filter for any sheet on the dashboard, which is not what you want. Selecting Deselect will clear any selections on the map, but it will not prevent Sales over time from being filtered by future selections. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_ignore.
htm
On a Tableau dashboard, when a map is used as a filter, it affects all other sheets in the dashboard by default.
To restrict the filter action to only affect the Detail table and not the 'Sales over time' chart, you would modify the action settings. By selecting "Ignore Actions" from the context menu of the 'Sales over time' chart, it will no longer respond to the filtering action initiated by selecting data points on the map.
NEW QUESTION # 26
You have the following visualization.
You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.
Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):
* Student ID 4183: 39 (Rank 1)
* Student ID 4220: 71 (Rank 6)
* Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank)
* Student ID 4124: 75.5
* Student ID 4050: 64
* Student ID 4205: 67
* Student ID 4056: 66
Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.
Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.
https://help.tableau.com/current/prep/en-us/prep_calculations.htm
NEW QUESTION # 27
You have the following dataset in Microsoft Excel.
You are using Data interpreter to cleans the dataset. Data interpreter provides the following results.
How many rows of data will be ingested into Tableau as values?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Data interpreter is a feature that helps you clean and structure your data in Excel before importing it into Tableau. It detects and removes any headers, footers, subtotals, or other elements that are not part of the actual data. It also splits any merged cells and fills in any missing values. In this case, data interpreter provides the following results:
* It removes the first three rows and the last two rows that contain headers and footers.
* It splits the merged cells in column A and fills in the missing values with "Fiction" or "Non-Fiction".
* It does not remove or change any other rows or cells.
Therefore, the number of rows of data that will be ingested into Tableau as values is 17, which is the number of rows left after removing the headers and footers. References: https://help.tableau.com/current/pro/desktop
/en-us/importing_cleaning_up_data.htm https://help.tableau.com/current/pro/desktop/en-us
/importing_data_interpreter.htm
Based on the Data Interpreter's results and the provided Excel dataset screenshot, the number of rows of data that will be ingested into Tableau as values is 17. The Data Interpreter has identified and excluded headers and footers, and the rows with actual data are considered for analysis.
NEW QUESTION # 28
You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.
To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)
Answer:
Explanation:
Explanation:
To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting "Add Show/Hide Button." You can also customize the appearance and behavior of the button.
To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.
The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.
References:
Add Show/Hide Buttons - Tableau
Layout Containers - Tableau
NEW QUESTION # 29
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 blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
- B. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
- C. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
- D. Add both sheets to the dashboard. Set Fit to Fix width.
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 # 30
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)
Answer:
Explanation:
Explanation:
The correct order of the three actions is:
* Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.
* Aggregate the date to month and year.
* From the Analytics pane, drag Forecast to the worksheet.
The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.
The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.
The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.
The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current
/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE
NEW QUESTION # 31
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. West
- B. South
- C. Central
- D. Cast
Answer: B
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 # 32
You have the following visualization.
You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.
Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):
* Student ID 4183: 39 (Rank 1)
* Student ID 4220: 71 (Rank 6)
* Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank)
* Student ID 4124: 75.5
* Student ID 4050: 64
* Student ID 4205: 67
* Student ID 4056: 66
Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.
Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.
https://help.tableau.com/current/prep/en-us/prep_calculations.htm
NEW QUESTION # 33 
You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.
What should you do?
- A. Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.
- B. Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.
- C. Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.
- D. Select the top 10 bars, and then change the color by selecting Color on the Marks card.
Answer: C
NEW QUESTION # 34
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.
Answer:
Explanation:
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
NEW QUESTION # 35
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.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
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.
References: https://help.tableau.com/current/pro/desktop/en-us/sets.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
NEW QUESTION # 36
A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:
* EmployeeInfo is the first table that is dragged to the canvas,
* The records must contain the Full Name, and the Department Name, Size, and VP fields if available,
* Not all records have an exact match.
Which type of join should the analyst use?
- A. Full outer
- B. Left
- C. Inner
- D. Union
Answer: B
NEW QUESTION # 37
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet.
* Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source.
* Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the existing data source.
* Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.
* Select Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_replace.htm https://help.tableau.com/current/pro/desktop/en-us/datasource_replace_workbook.htm
NEW QUESTION # 38
A Data Analyst has the following bar chart.
The analyst wants the chart to appear as shown in the following exhibit.
What should the analyst add?
- A. A reference band
- B. A reference line
- C. An average line
- D. A distribution band
Answer: D
NEW QUESTION # 39
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.)
- A. IF [Sales] > 50000 THEN TRUE ELSE FALSE END
- B. MAX([Sales], 50000)
- C. SUM([Sales]) IN (50000)
- D. [Sales] > 50000
Answer: A,D
NEW QUESTION # 40
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
- A. From the Server menu, select Tableau Public, and then select Save to Tableau Public.
- B. From the Server menu, select Publish Data Source.
- C. From the Server menu, select Publish Workbook.
- D. From the File menu, select Export Packaged Workbook.
Answer: C
Explanation:
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
NEW QUESTION # 41
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 # 42
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Spelling
- B. Common Characters
- C. Manual Selection
- D. Pronunciation
Answer: A
Explanation:
Tableau Prep's Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.
NEW QUESTION # 43
......
Get ready to pass the Analytics-DA-201 Exam right now using our Tableau Data Analyst Exam Package: https://www.freecram.com/Salesforce-certification/Analytics-DA-201-exam-dumps.html
A fully updated 2026 Analytics-DA-201 Exam Dumps exam guide from training expert FreeCram: https://drive.google.com/open?id=1Wi4RCzFZFbYpr0rvc7h17f3gm6lou1bn