Salesforce Certified Tableau Data Analyst Practice Questions
Prepare for Analytics-DA-201 with more than an answer.
- Exam fee
- $200 USD
- Level
- Intermediate
- Valid for
- Annual maintenance required
Domains covered on the exam 4
- Connect to and Transform Data24%
- Explore and Analyze Data41%
- Create Content26%
- Publish and Manage Content on Tableau Server and Tableau Cloud9%
- 1
A dataset contains a field 'Order ID' in the format 'US-2023-10543'. You need to extract just the year '2023' from this string to create a new field named 'Order Year'.
Which calculation will achieve this?
Show answer details
Correct answer: B
The SPLIT function divides a string based on a delimiter (hyphen '-') and returns the token at the specified position (2). For 'US-2023-10543', the second token is '2023'.
- 2
You have a dashboard containing a map and a bar chart. You want users to be able to click on a state in the map and have the bar chart filter to show only data for that state. However, when the user deselects the state, you want the bar chart to show all data again.
How should you configure the Filter Action?
Show answer details
Correct answer: C
This configuration ensures that selecting a mark applies the filter, and clearing the selection (clicking the background) removes the filter, revealing all data. This is the standard behavior for interactive drill-down analysis.
- 3
True or False: In Tableau, a Context Filter is applied AFTER a Fixed Level of Detail (LOD) expression is calculated.
Show answer details
Correct answer: B
False. In Tableau's Order of Operations, Context Filters are applied BEFORE Fixed LOD expressions. This means if you want a Fixed LOD to respect a filter, you must add that filter to Context.
- 4
A data analyst is designing a data model in Tableau Desktop using two tables: 'Orders' and 'Returns'. The goal is to analyze all orders, regardless of whether they were returned or not, while also identifying which orders have associated return records. Performance is a priority, and the analyst wants to ensure that queries are optimized by culling unnecessary joins when the 'Returns' data is not specifically requested in the visualization.
Which modeling approach should the analyst use?
Show answer details
Correct answer: A
Relationships (the logical layer) are flexible and optimize performance by generating queries only for the tables relevant to the specific analysis. This 'join culling' behavior ensures that if a visualization only uses fields from 'Orders', the 'Returns' table is not queried. A physical Left Join would fix the join type upfront and might query both tables unnecessarily.
- 5
A multinational retailer stores sales data in separate Excel files for each region (North, South, East, West). Each file has the same column structure but different file names. The data analyst needs to combine these files into a single table for analysis in Tableau Prep Builder. The solution must automatically include new regional files added to the folder in the future.
Which step should the analyst take?
Show answer details
Correct answer: C
A Wildcard Union in the Input step allows Tableau Prep to scan a specified directory and union all files that match a naming pattern (e.g., Sales_*.xlsx). This dynamic approach ensures that future files added to the folder are automatically included in the flow without manual intervention.
- 6
You are analyzing a dataset containing 'Product ID' and 'Sales'. You want to calculate the total sales for each product, but you want this calculation to ignore any dimension filters applied in the view, such as 'Region' or 'Segment'. However, you still want the calculation to respect Context filters.
Which Level of Detail (LOD) expression should you use?
Show answer details
Correct answer: D
FIXED LOD expressions calculate values using the specified dimensions, ignoring other dimensions in the view. According to Tableau's Order of Operations, FIXED LODs are computed after Context filters but before Dimension filters. This makes FIXED the correct choice for ignoring standard dimension filters while respecting context filters.
