Free Preparation Discussions
MENU
Salesforce Analytics-DA-201 Exam Questions
- Topic 1: Connect To and Transform Data: This domain focuses on connecting to various data sources such as files, databases, and published sources, while deciding between live and extract connections. It also covers preparing, cleaning, transforming, and organizing data using Tableau features and Tableau Prep to ensure it is ready for accurate analysis.
- Topic 2: Explore and Analyze Data: This section covers creating calculations, applying filters, parameters, and structuring data to explore insights effectively. It also includes advanced analysis techniques such as table calculations, LOD expressions, forecasting, and geographic mapping to derive meaningful patterns and trends.
- Topic 3: Create Content: This domain involves building visualizations like charts, dashboards, and stories to present data insights clearly. It also focuses on adding interactivity, formatting, and designing responsive dashboards to enhance user experience and data communication.
- Topic 4: Publish and Manage Content on Tableau Server and Tableau Cloud: This section covers publishing workbooks, data sources, and flows to Tableau Server or Cloud for sharing and collaboration. It also includes managing content through scheduling refreshes, setting permissions, and creating alerts, subscriptions, and custom views.
Free Salesforce Analytics-DA-201 Exam Actual Questions
Note: Premium Questions for Analytics-DA-201 were last updated On Jun. 29, 2026 (see below)
You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
* Every record must have a full name.
Which type of join should you use?
To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this:
Join Your Data - Tableau
Join Types in Tableau
You have the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter.Reference:
LOOKUP Function - Tableau
Table Calculations - Tableau
Tableau Certified Data Analyst Study Guide
A Data Analyst needs to analyze the financial performance of the sales team. In order to make the dashboards easier to understand, the analyst needs to format the financial values to show the dollar symbol ($) in front of the value.
How should the analyst enable this formatting across the workbook?
A Data Analyst has a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.
The analyst wants to ensure that every calculation is affected by including only animals of a particular type.
Which type of filter should the analyst create on the worksheet?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Brenda Brown
8 days agoBrenda Lee
29 days agoJason Baker
1 month agoGerald Garcia
2 months agoBrenda Stewart
2 months agoRachel Baker
2 months agoJason Martin
2 months agoThomas Collins
2 months agoGeorge Reed
2 months agoMirta
3 months agoAnnice
3 months agoCandra
3 months agoJennie
4 months agoEmogene
4 months agoNa
4 months agoSherron
4 months agoGlory
5 months agoGregoria
5 months agoJose
5 months agoToshia
5 months agoTammi
6 months agoTanja
6 months agoRosio
6 months agoRebbecca
6 months agoLizette
7 months agoLazaro
7 months agoJesusa
7 months agoElvera
7 months agoEsteban
8 months agoIsabelle
8 months agoKeena
8 months agoKanisha
8 months agoFlorinda
9 months agoAvery
9 months agoVal
9 months agoAlishia
9 months agoAmos
10 months agoTamar
10 months ago