Analytics-DA-201 Sample Questions & Answers
Built around exploring and analyzing data through filters, calculated fields and table-level math, the single biggest weight, plus connecting to data sources and transforming it in Tableau Prep, creating charts and dashboard stories, then publishing to Server or Cloud.
Launch the full Analytics-DA-201 simulator →Showing 6 of 12 free samples.
- Question 1Beginner
Create Content · Add interactivity to dashboards
A dashboard contains a scatter plot showing 'Profit' vs. 'Sales'. The analyst wants to allow users to click a button to toggle the visibility of a 'Parameters' container that holds several control settings. The container should appear floating over the chart when needed and disappear to save screen space when not in use.
Which feature should the analyst implement?
Show answer & explanation
Correct answer: D
The Show/Hide button feature allows users to toggle the visibility of floating (and tiled, in newer versions) containers. This is the standard method for creating collapsible menus or parameter panels that float over the dashboard content.
- Question 2Intermediate
Connect to and Transform Data · Perform data transformation in Tableau Prep
You have a Tableau Prep flow that processes monthly sales data. The output is a .hyper file used by several dashboards. You need to configure the Output step so that every time the flow runs, the new monthly data is added to the existing .hyper file without removing the historical data.
Which Write Option should you select in the Output step?
Show answer & explanation
Correct answer: D
'Append to table' adds new rows from the flow to the existing table (or file) without overwriting existing data. This is the correct method for accumulating historical data. 'Create table' or 'Replace data' would overwrite the existing file.
- Question 3Intermediate
Create Content · Create charts
A data analyst creates a dual-axis chart comparing 'Sales' (Bar) and 'Profit Ratio' (Line) over 'Order Date'. The Sales axis ranges from 0 to 1,000,000, while the Profit Ratio axis ranges from -0.5 to 0.5. The analyst observes that the zero lines for the two axes are not aligned, making the visual comparison difficult.
What should the analyst do to align the zero lines?
Show answer & explanation
Correct answer: A
Synchronizing axes aligns the scales of dual axes. However, this often requires the data types to be compatible (e.g., both decimals). Since Profit Ratio is a percentage (decimal) and Sales is usually a whole number or decimal, ensuring type compatibility allows synchronization, which forces the zero baselines to align.
- Question 4Beginner
Explore and Analyze Data · Map data geographically
You are creating a geographic map to visualize customer density. You have a dataset with latitude and longitude fields. You want to visualize the concentration of customers using a heatmap style where areas with more points appear more intense in color, without plotting individual marks.
Which Mark type should you select?
Show answer & explanation
Correct answer: B
The Density mark type (also known as a heatmap) is designed specifically to show the concentration or intensity of data points in a geographic area. It aggregates overlapping points into color gradients representing density.
- Question 5Intermediate
Publish and Manage Content on Tableau Server and Tableau Cloud · Schedule data updates
A user reports that a dashboard on Tableau Server is not updating with the latest data. The data source is an Extract of a SQL Server database. The extract refresh task is scheduled to run daily at 3:00 AM. Upon investigation, you see the refresh task failed with an authentication error.
What is the most likely cause?
Show answer & explanation
Correct answer: D
Extract refreshes on Tableau Server require valid credentials to connect to the underlying database. If the authentication fails, it is typically because the embedded password has changed, the account is locked, or the credentials were not properly embedded during publishing.
- Question 6IntermediateSelect 2
Explore and Analyze Data · Create and use filters
You need to create a filter that allows users to select the 'Top N' customers by Sales, where N is a value selected by the user from a dropdown list (e.g., 5, 10, 20).
Which two components are required to achieve this? (Select TWO)
Show answer & explanation
Correct answers: B, C
To limit the view to the top customers, you must apply a filter on the Customer Name dimension. In the 'Top' tab of the filter configuration, you can select 'By Field' -> 'Top' and then choose the created parameter instead of a static number.
An integer parameter is needed to capture the user's input (N) for the number of customers to show.
Ready for the real thing?
The full Analytics-DA-201 simulator has every exam-style question, timed mode, and instant scoring.