Salesforce Analytics-DA-201 Practice Exam Questions & Answers

7 Free Questions Last reviewed November 15, 2026 Prepared & Reviewed by the ValidExamDumps Editorial Team

174 Practice Questions (Our Bank)
105 minutes Exam Duration
USD 250 Official Exam Fee
Exam Facts

Salesforce Analytics-DA-201 Exam Details

Key details for this exam, checked against the published exam outline

Exam Code
Analytics-DA-201
Full Name
Salesforce Certified Tableau Data Analyst
Issuing Body
Salesforce
Question Format (Our Bank)
Multiple Choice, Hotspot, Order List, Drag & Drop
Validity
3 years
Practice Questions

Free Analytics-DA-201 Practice Questions

Each question shows the correct answer and an explanation of why it is right

VA
ValidExamDumps Editorial Team Every question and its answer is checked by our Analytics-DA-201 exam preparation team, who also write the explanation shown with each one. How we research and review these pages

Question 1 Domain 4 Publish and Manage Content on Tableau Server and Tableau Cloud

You create the following worksheet

Question 1 exhibit

The Pick Measure parameter contains the following list of values

Question 1 exhibit

Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.

Which formula is used in the Selected Measure calculated field lo switch between measures?

Correct Answer A
Explanation

https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm

This formula uses a parameter (Pick Measure) to switch between the Sales and Profit measures. When the user selects '1', it shows Sales, and when '2' is selected, it shows Profit. This dynamic switching is enabled by the Case function.

Question 2 Domain 3 Create Content

A Data Analyst creates the following story that contains two story points.

Question 2 exhibit

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?

Correct Answer A
Explanation A Tableau Prep flow can output to a .hyper file, which is Tableau's optimized extract format. The colleague exports the flow results to .hyper, and the analyst then connects to this file through Tableau Desktop's file connection options. This allows the analyst to start dashboard work before the flow is formally published to the server.

Question 3 Domain 2 Explore and Analyze Data

A Data Analyst has the following primary data source that contairis a dimension named Dorm_Code.

Question 3 exhibit

The analyst receives the following secondary data source that contains updated dorm codes.

Question 3 exhibit

The analyst needs to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.

What should the analyst do?

Correct Answer D
Explanation FIXED level of detail expressions calculate at a specific granularity regardless of what's in the view. When you add a dimension filter to context, it applies globally to all calculations including LOD expressions. This ensures the five excluded states are removed before the FIXED calculation runs. Right-clicking the filter and selecting Add to Context moves it above all other filters in calculation order.

Get the complete Analytics-DA-201 question set $20$40

Get Full Access

Question 4 Domain 2 Explore and Analyze Data

SIMULATION

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.

Question 4 exhibit

Correct Answer A
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.

Question 5 Domain 3 Create Content

You have the following dataset.

Question 5 exhibit

Which grouping option should you use m Tableau Prep to group al five names automatically?

Correct Answer B
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.

Question 6 Domain 3 Create Content

SIMULATION

Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.

Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.

Question 6 exhibit

Correct Answer A
Explanation

To modify the bar chart to show the percentage of sales for each Subcategory within every Category, 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 CategoryPercentage worksheet.

Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.

Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.

Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.

Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.

Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.

Question 7 Domain 2 Explore and Analyze Data

A Data Analyst is given the following table and asked to create a flow that adds a date field to the dat

a. This field should automatically update as new dates (months) are added to the original table.

Question 7 exhibit

Which technique should the analyst use as the first step to achieve this in Tableau Prep?

Correct Answer D
Explanation Converting a date field to continuous in Tableau creates a linear axis where months display in chronological order as equally spaced points. Discrete dates create separate bars or marks for each month. For a cumulative sales chart showing progression over time, continuous dating provides the right visual progression. Sorting or renaming dates won't give you the continuous axis behavior needed for this type of chart.
Study Guide

What the Salesforce Analytics-DA-201 Exam Covers

Exam domains verified against the Official Salesforce Analytics-DA-201 exam guide, last checked November 2026.

Domain 1 Connect To and Transform Data

24%

Master connecting to various data sources including files, databases, and Tableau Server or Cloud. Learn to assess data quality, perform cleaning operations, and prepare data using Tableau Prep with unions, joins, and aggregations.

Domain 2 Explore and Analyze Data

41%

Build calculated fields using date, string, logical, numeric, and aggregate functions. Create table calculations for moving averages, running totals, rankings, and percentiles. Apply filters, parameters, and Level of Detail expressions to enable deeper analysis.

Sample questions from this domain above Q3Q4Q7

Domain 3 Create Content

26%

Design and build charts, dashboards, and stories from scratch. Add interactivity through filters, actions, and parameters. Format visualizations with colors, shapes, annotations, tooltips, and responsive layouts for different devices.

Sample questions from this domain above Q2Q5Q6

Domain 4 Publish and Manage Content on Tableau Server and Tableau Cloud

9%

Publish workbooks and data sources to Tableau Server or Cloud. Schedule extract refreshes and manage published content through alerts, subscriptions, and custom views. Understand user roles and permissions for content distribution.

Sample question from this domain above Q1

FAQ

Analytics-DA-201 Exam FAQ

Common questions about the exam itself

What background do I need before taking the Analytics-DA-201 exam?
You should have practical experience with Tableau Desktop, understanding how to connect to data sources, create visualizations, and build basic dashboards. Hands-on work with calculated fields, filters, and dashboard design is essential. The exam tests applied skills, not just theory, so work with real data before attempting it.
How long should I study to prepare for Analytics-DA-201?
Most candidates prepare for 4 to 8 weeks, depending on their existing Tableau experience. If you already work with Tableau regularly, 4 weeks of focused study on the exam outline topics may be enough. Without hands-on experience, allow 8 to 12 weeks to build the practical skills the exam requires.
What is the hardest section of the Analytics-DA-201 exam?
The Explore and Analyze Data domain accounts for 41 percent of the exam weight and covers the most complex topics: Level of Detail expressions, table calculations, and advanced calculated fields using multiple function types. Start preparing this section early and practice writing real formulas in Tableau, not just memorizing syntax.
How many questions are on Analytics-DA-201 and how long does it take?
The exam has 60 questions and you have 105 minutes to complete it. This gives roughly 1.75 minutes per question, so you need to work efficiently. Practice with timed mock exams to build the speed and accuracy the real exam demands.
What score do I need to pass Analytics-DA-201?
Salesforce does not publicly disclose the exact passing score for this exam. Most Salesforce Tableau exams use a scaled scoring method rather than a simple percentage, so focus on understanding concepts deeply rather than aiming for a specific number.
Can I retake the Analytics-DA-201 exam if I fail?
Yes, you can retake the exam after a 1-day waiting period if it is your first retake. Subsequent retakes require a 14-day waiting period. You can attempt the same exam up to 6 times per year. Each retake costs the full exam fee.
How long is the Salesforce Certified Tableau Data Analyst certification valid?
Your certification is valid for 3 years from the date you pass the exam. After 3 years, you must retake the exam or complete continuing education to maintain the credential. Salesforce periodically updates the exam content, so check closer to your renewal date for any changes.
What job roles does Analytics-DA-201 prepare me for?
This certification prepares you for data analyst positions focused on analytics and visualization. Professionals use it to move into roles like Business Intelligence Analyst, Analytics Developer, or Tableau Specialist. It validates the mid-level skills employers expect for analytics roles working with Tableau.
How does Analytics-DA-201 relate to other Tableau certifications?
Analytics-DA-201 is the intermediate Tableau credential. The Tableau Desktop Foundations exam is entry-level and covers basic skills. The Tableau Consultant and Server Admin certifications are advanced options for different career paths. Most data analysts target the Data Analyst cert after gaining desktop experience.
Is Analytics-DA-201 administered online or at a test center?
Salesforce Tableau exams are delivered online and proctored remotely, so you can take the exam from home or an office with a reliable internet connection. You need a quiet space, a working webcam, and a clear desk for the duration of the exam.

Other Salesforce Exams

Free practice questions for more Salesforce certification exams

All Salesforce exams