Free TDA-C01 Practice Test Questions and Answers (2026)

To create the Position column, you should use the FIRST () function. The FIRST () function returns the

number of rows from the current row to the first row in the partition. For example, the first row in a

partition will return 0, the second row will return -1, and so on. In this question, the partition is

defined by the Segment field, and the table is sorted by the Sales field in descending order.

Therefore, the Position column shows the offset of each row from the first row in each segment,

based on the sales ranking. Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 11, section “Creating Calculated Fields”

Tableau Help: FIRST Function

To ensure that the data is updated every hour, you need to select Extract Refreshes from the data

source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an

existing one. You can specify the frequency and time of the refresh, as well as any custom options or

credentials. New will create a new data source, Connected Workbooks will show you which

workbooks use this data source, and Connections will show you which tables or files are connected

to this data source. Reference: https://help.tableau.com/current/server/en-us/refresh_extracts.htm

https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

To combine the two tables that contain data about books in a library and ensure that all the data is

retained, you should use a full outer join. A full outer join is a type of join that returns all rows from

both tables, regardless of whether there is a match or not. If there is no match, null values are filled

in for the missing fields.

To perform a full outer join, you need to do the following steps:

Connect to both tables as your data sources in Tableau. You can use either live or extract connections.

Drag one table to the canvas and drop it on top of another table. This will create a join between them

based on a common field.

Click on the join icon between the tables and select Full Outer Join from the drop-down list. This will

change the join type to full outer join and show all rows from both tables.

Optionally, you can add or remove join clauses by clicking on Add or Remove buttons next to each

clause. You can also change or rename fields by clicking on them.

The other types of joins are not correct for this scenario. An inner join returns only the rows that

have a match in both tables, which will exclude any books that are missing from either table. A left

join returns all rows from the left table and only the matching rows from the right table, which will

exclude any books that are only in the right table. A right join returns all rows from the right table

and only the matching rows from the left table, which will exclude any books that are only in the left

table. Reference: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm

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

we need to create a quick table calculation that shows the percent of total sales for each category

and sub-category. To do this, we can follow these steps:

Drag Category to Columns and Sub-Category to Rows.

Drag Sales to Text on the Marks card.

Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total.

Right-click Sales on the Marks card again and select Compute Using > Category.

This will create a quick table calculation that shows the percent of total sales for each sub-category

within each category. The visualization will look like this:

To replace a sheet on a tiled dashboard, you can simply drag the new sheet from the Sheets pane to

the dashboard and drop it over the existing sheet. This will replace the old sheet with the new one

and keep the same size and position. Alternatively, you can right-click on the old sheet and select

Replace Data Source, then choose the new sheet from the list. Reference:

https://help.tableau.com/current/pro/desktop/enus/dashboards_organize_floating_layoutcontainers.htm

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

A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed

and optimized file format that can be used to improve the performance and portability of

dashboards and workbooks. A .twb file is a workbook file that contains the visualization and

connection information, but not the data itself. A .csv file is a comma-separated values file that

contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries,

forms, and other objects. Reference: https://help.tableau.com/current/pro/desktop/enus/save_savework_packagedworkbooks.htm https://help.tableau.com/current/pro/desktop/en-

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

https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c4a0b-8e6c-6d1f1f7c2b7e

The value that will appear in the crosstab for the Consumer segment of the year 2018 if you change

compute to use Order Date is 0. The Last() calculation is a table calculation that returns the number

of rows from the current row to the last row in the partition. The partition is determined by how you

compute the calculation. In this case, you change compute to use Order Date, which means that the

calculation will be performed for each value of Order Date.

The crosstab shows that there are two values of Order Date for the Consumer segment of the year

2018: Q1 and Q4. The Last() calculation will return 0 for Q4, because it is the last row in the partition.

It will return 1 for Q1, because it is one row away from the last row in the partition.

The other options are not correct for this scenario. The Last() calculation will not return 2, 3, or 4 for

any value of Order Date, because there are only two values in each partition.

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

https://help.tableau.com/current/pro/desktop/enus/calculations_tablecalculations_functions.htm#LAST

To group all five names automatically, you should use Manual Selection as a grouping option in

Tableau Prep. Manual Selection is a feature that allows you to select values from your data and group

them together based on your criteria. You can use Manual Selection by clicking on Group Values in

Profile pane > Manual Selection from the menu. This will open a dialog box where you can select

values from your data and assign them to a group.

In this case, you want to group all five names together based on their spelling variations. You can use

Manual Selection by selecting all five values from your data and assigning them to a group named

“Harry Potter”. This will create a new field named Grouped Field that contains “Harry Potter” as one

value.

The other options are not correct for this scenario. Pronunciation is a feature that groups values

based on how they sound, but it may not work well with names or uncommon words. Spelling is a

feature that groups values based on common spelling errors or typos, but it may not recognize all

variations or synonyms. Common Characters is a feature that groups values based on the number of

characters they share, but it may not capture the meaning or context of the values. Reference:

https://help.tableau.com/current/prep/en-us/prep_group.htm

https://help.tableau.com/current/prep/en-us/prep_group_manual.htm

To create a boolean calculated field to place on the data source filter, you should use the formula

USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name

matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data

source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the

data to show only the rows that are relevant to the specific Tableau user.

The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in

Tableau. ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. ‘S’ +

STR([Sales]/1000) is not a boolean expression, but a string expression that converts sales to

thousands with a prefix of “S”. Reference: https://help.tableau.com/current/pro/desktop/enus/filtering_datasource.htm https://help.tableau.com/current/pro/desktop/en-

us/functions_functions_logical.htm#USERNAME https://help.tableau.com/current/pro/desktop/enus/calculations_calculatedfields.htm

To configure the dashboard action, you should select Filter as the action type, Select as the run action

on option, and All Fields as the target filters option. This will ensure that when a user selects a city on

the map, the bar chart will show only the data for the selected city based on all fields in common

between the two worksheets. The action will run only when the user selects a different city.

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

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

.

Explanation:

To create a filled map to show the distribution of total Sales by State across the United States, you

need to do the following steps:

Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the

Superstore data source.

Click on the Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank

worksheet with no marks.

Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows

each state as a mark. You may need to zoom in or out to see the whole map.

Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that

shows the distribution of total Sales by State across the United States. The color legend will show you

the range of values and colors for Sales.

Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking

on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your

map.

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

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

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

To add a column that shows the day of the week for each row, you should complete the formula as

follows:

DATENAME

(

‘weekday’

, [Order Date])

The DATENAME function in Tableau returns the name of a specified part of a date or datetime value,

such as the year, month, or day. It takes two arguments: the date part and the date. In this question,

you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each

order date. Therefore, you need to use ‘weekday’ as the date part and [Order Date] as the date. The

formula will return a string value that represents the name of the weekday for each order date.

Reference:

Tableau Help: DATENAME Function

Tableau Help: Date Functions

To add a column that shows the day of the week for each row, you should complete the formula as

follows:

DATENAME

(

‘weekday’

, [Order Date])

The DATENAME function in Tableau returns the name of a specified part of a date or datetime value,

such as the year, month, or day. It takes two arguments: the date part and the date. In this question,

you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each

order date. Therefore, you need to use ‘weekday’ as the date part and [Order Date] as the date. The

formula will return a string value that represents the name of the weekday for each order date.

Reference:

Tableau Help: DATENAME Function

Tableau Help: Date Functions

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDA-C01/page_72_img_2.jpg

To add two sheets to the dashboard that support the Show/Hide button, you can add them to either

a horizontal or a vertical container. A container is an object that can hold one or more sheets or other

objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide

or show a container and its contents on the dashboard. You can add a Show/Hide button to any

container, whether it is tiled or floating, by using the drop-down menu of the container and selecting

“Add Show/Hide Button.” You can also customize the appearance and behavior of the button.

To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects

pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a

vertical container will arrange them vertically. You can then drag the sheets you want to add from the

Sheets pane to the container. You can resize and reorder the sheets or objects within the container by

using the handles and arrows.

The other objects in the Answer Area, such as text, image, web page, blank, navigation, download,

and extension, do not support the Show/Hide button. They are either static elements that cannot

hold other objects, or dynamic elements that require user interaction or external sources. You can

add them to the dashboard as well, but they will not have the same functionality as a container with

a Show/Hide button.

Reference:

Add Show/Hide Buttons - Tableau

Layout Containers - Tableau

.

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.

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

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

https://help.tableau.com/current/pro/desktop/enus/calculations_tablecalculations_percentoftotal.htm

To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text

file in Tableau Desktop. This option will allow you to browse and select the file from your local or

network drive and connect to it as a data source. You can then specify the text file properties, such as

the delimiter, the text qualifier, and whether the first row contains column names. You can also join,

union, or blend the data with other data sources if needed. Reference:

Text File - Tableau

Tableau Certified Data Analyst Study Guide

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/enus/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro/desktop/en-

us/calculations_calculatedfields_lod_rank.htm

The object that you should add to the dashboard to allow users to switch to a different dashboard in

the workbook is Navigation.

Navigation objects are used to create links between dashboards or sheets in a workbook. You can

add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the

dashboard. You can then configure the navigation object to specify the destination dashboard or

sheet that you want users to navigate to when they click on it.

You can learn more about navigation objects and how to use them in this article:

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

To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and [Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.

Finding the Month-to-Date Values for the Prior Year [DATEADD Function] [DATETRUNC Function]

The first action is to connect to both data sources from the connections pane in Tableau Prep. The connections pane is where you can access and add data sources to your flow. You can connect to various types of data sources, such as Excel, SQL Server, or Tableau Server. In this case, you want to connect to an Excel worksheet and a SQL Server table. The second action is to join both datasets and select the join type. A join is a way of combining data from two or more tables based on a common field. You can join datasets by dragging one table to the canvas and dropping it on top of another table. This will create a join step in your flow. You can select the join type from the drop-down list on the join step. The join type determines which rows are returned from the tables. The third action is to specify Employee Name as the join key. A join key is a field that is used to match rows from different tables. You can specify the join key by clicking on the field name in each table and dragging it to the center of the join step. This will create a join clause that shows the field name and the operator. In this case, you want to use Employee Name as the join key, because it is a common field between the two datasets. The other options are not relevant for this scenario. Specifying Department and Team Size as a join condition will not work, because they are not common fields between the two datasets. Opening both data sources in Tableau Desktop will not help you join them in Tableau Prep. Adding a step to aggregate the data in the SQL Server table will not affect the join, but it may change the level of detail of your dat a.

https://help.tableau.com/current/prep/en-us/prep_connect.htm https://help.tableau.com/current/prep/en-us/prep_join.htm https://help.tableau.com/current/prep/en-us/prep_join_types.htm

The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default. The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month. The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card. The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.

https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro/desktop/enus/functions_functions_statistical.htm#MODEL_QUANTILE