TDA-C01 Exam Preparation Material | Tableau Certified Data Analyst Exam

Prepare for the TDA-C01 with reliable study materials, practice questions, and key exam insights.

Prepare for the TDA-C01 Tableau Certified Data Analyst exam with CertQueen's independently developed study resources. Review important concepts, practice scenario-based questions, and use clear explanations to identify areas that require further study.

Question#1

HOTSPOT
You have the following dataset.



Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula?


A. 

Explanation:
To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every [Category], which means that the ranking will reset for each category.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm
https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_rank.htm

Question#2

DRAG DROP
You conned to a Microsoft SQL Server database.
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned.
How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)


A. 

Explanation:
Select
Where
The correct way to complete the query is:
SELECT * FROM [dbo] . [Students]
WHERE [Students].[City] = ‘Berlin’
The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all columns will be returned. The FROM clause specifies the table or view name and the schema name. The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] = ‘Berlin’, which means that only rows where the City column of the Students table is equal to ‘Berlin’ will be returned.
The other options are not relevant for this query. CAST is a function that converts a value from one data type to another. JOIN is a clause that combines data from two or more tables based on a common field. ON is a keyword that specifies the join condition. UNION is a set operation that combines the results of two or more queries into one result set.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver15#join
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-server-ver15

Question#3

Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.


A. To filter the table to show the Top 10 NOC based on the number of medals won, 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 NOC, discipline, and medals for each country.
Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm

Question#4

HOTSPOT
You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data''


A. To aggregate data, implying you would be doing it before the join, you'd use the summarise/aggregation tool that E. Therefore, the answer should be the Epsilon E.

Question#5

You have the following dataset.



Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

A. {FIXED: [Region] SUM Sales}
B. {FIXED: SUM Sales}
C. {Fixed: [Region]: TOTAL Sales}
D. {FIXED: TOTAL (Sales)}

Explanation:
To calculate the grand total of all the regions, you need to use a Level of Detail (LOD) expression that ignores any dimensions in the view and returns the total sum of sales. The FIXED keyword allows you to specify the level of detail for the calculation, and the TOTAL function returns the sum of all values in the expression. Therefore, the correct LOD expression is {FIXED: TOTAL (Sales)}.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL

Exam Code: TDA-C01
Q & A: 120 Q&As         Updated:  Oct 07,2026

 

 Access Complete TDA-C01 Preparation Material

What This TDA-C01 Study Resource Helps You Do

Review Key Concepts

Review the technologies, products, processes, and practical skills covered by the current TDA-C01 exam objectives.

Practice Scenario-Based Questions

Work through independently developed questions designed to strengthen your understanding of technical scenarios and decision-making.

Identify Knowledge Gaps

Use your results and the provided explanations to find weaker areas and focus your study more effectively.

How to Use This TDA-C01 Preparation Material

Review the Exam Scope

Start by reviewing the topics covered by the TDA-C01 exam. Compare them with the official exam objectives to understand the required technologies, operational tasks, and practical skills, then identify the areas that deserve the most attention.

Practice Independently

Complete a focused set of practice questions for each topic. On your first attempt, avoid referring to notes, answers, or other study resources so that you can evaluate your current understanding more accurately.

Study the Explanations

Review the answers and explanations after completing each practice session. Understand why the correct option is appropriate for the given scenario and why the other options may be incorrect or less suitable.

Close Knowledge Gaps

Keep track of incorrect answers, unfamiliar concepts, and weaker knowledge areas. Review these topics using official documentation and practical experience, then answer the related questions again to reinforce your understanding and monitor your progress.

Independent TDA-C01 Preparation Resource

CertQueen independently develops its certification study materials for educational purposes. The practice questions are not copied from, recalled from, or presented as live or official exam questions.

CertQueen is not affiliated with, endorsed by, sponsored by, or authorized by any certification provider. Certification names, exam codes, product names, and related trademarks are the property of their respective owners and are referenced only for identification and educational purposes.

Exam Code: TDA-C01
Q & A: 120 Q&As
Updated:  Oct 07,2026

 

 Access Complete TDA-C01 Preparation Material