Analytics-DA-201 Salesforce Certified Tableau Data Analyst Free Practice Exam Questions (2026 Updated)

1) Open Tableau prep

2) Create a new column ...

3) Union the sales ...

4) Join the sales ...

To have each record alternate between grey and white, you should change the row banding size to 1 in the Format Shading pane. This setting will ensure that each row has a different shading from the one above and below it, creating an alternating pattern of grey and white rows. References: The answer can be verified through practical application within Tableau or by consulting Tableau’s official learning resources, such as  Tableau Help: Format Shading  or  Tableau Training Pass: Formatting .

To complete the formula, you should drag the option MAX from the list of options and drop it into the first blank space, and then drag the option [Sales] and drop it into the second blank space. The formula will look like this: Option (MAX) Option ([Sales] ). This formula will calculate the maximum value of the sales field for each country. You can use this formula to create a calculated field that will show the highest sales amount for each country in your data source. References:

Create a Simple Calculated Field - Tableau

MAX Function - Tableau

Tableau Certified Data Analyst Study Guide

To resume a suspended alert, you need to go to the My Content area of Tableau web pages, where you can see all the alerts that you own or subscribe to. You can click on the alert name and then select Resume from the menu. You can also edit or delete the alert from there. References: https://help.tableau.com/current/pro/desktop/en-us/alerts.htm https://help.tableau.com/current/pro/desktop/en-us/alerts_manage.htm

In Tableau, the " My Content " area on the web interface is the place where a user can manage their content, including workbooks, data sources, and alerts. If an alert is suspended, the owner of the alert can go to the " My Content " area to resume it.

Tableau Desktop provides a dedicated Swap Sheets capability for replacing one dashboard worksheet with another while retaining much of the original dashboard object’s formatting. The correct workflow is to first select Sheet 3 on the dashboard, hover over Sheet 2 in the Sheets list, and click the Swap Sheets button. Tableau’s current documentation describes this procedure for replacing dashboard sheets. It also notes that padding, border, and background color are retained, although the replacement may require size adjustments if its content differs. Removing Sheet 3 would simply delete the current dashboard item. Adding Sheet 2 separately would not perform the controlled replacement, and Deselect has no role in sheet replacement. Therefore, D is the correct Tableau Desktop workflow.

A standard dimension filter is evaluated after a FIXED Level of Detail expression in Tableau’s order of operations. FIXED LOD calculations establish their result using the dimensions specified in the expression without reference to the dimensions currently in the view, and they are computed before ordinary dimension filters. Consequently, applying a normal dimension filter changes which marks or records are displayed in the worksheet, but it does not recalculate the FIXED result based on that filter. If the analyst needs the filter to affect the FIXED LOD, the filter can be promoted to a context filter because context filters are evaluated earlier. The question specifies only a dimension filter, so the correct behavior is that the displayed data changes while the FIXED LOD calculation remains unaffected.

In Tableau dashboards, floating elements are those that can be freely moved over the dashboard canvas without being snapped into the tiled layout. The floating elements are often indicated by their standalone frames and the ability to overlap with other dashboard items. From the provided image, the state filter and the Rate of Obesity chart can be identified as floating if they can be moved independently of the tiled grid layout that constrains other elements.

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.

Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.

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.

For a published data source used by multiple viewers and explorers, row-level security should be enforced centrally at the data-source level. Tableau supports user-based security calculations that identify the signed-in user and return only the rows that user is entitled to see. Placing the security logic in a data source filter before publishing ensures that every workbook connected to that published source receives the restricted data. Tableau also prevents downstream authors from seeing or modifying those data source filters, which strengthens consistency across consuming workbooks. A normal dimension filter in an individual worksheet is easier to change and is not a centralized RLS control. Data source permissions control access to the published asset itself, not which rows an authorized user can see. Therefore, option C best implements the stated row-level security requirement.

A reference line is used in Tableau to display a line at a constant value or a computed value such as an average, median, minimum, or maximum in a bar chart. In this case, adding a reference line would allow you to show the median, upper quartile, and lower quartile, which corresponds to the changes shown in the bar chart.