[Q40-Q61] Ensure Success With Updated Verified TDA-C01 Exam Dumps [2026]

ExamBoosts avril 11, 2026 TDA-C01 > Tableau 0

Notez cet article

Ensure Success With Updated Verified TDA-C01 Exam Dumps [2026]

Exam Materials for You to Prepare & Pass TDA-C01 Exam.

Tableau TDA-C01 certification is a valuable credential for data analysts who wish to demonstrate their expertise in using Tableau for data analysis and visualization. It provides a standardized way for employers to assess a candidate’s skills and knowledge in this area. By passing TDA-C01 exam, individuals can enhance their career prospects and showcase their ability to analyze and communicate insights from complex data sets.

Q40. In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?

TRIM

CONTAINS

REPLACE

SPLIT

The REPLACE function is used to replace all occurrences of a substring within a string with another substring. In this case, it can be used to remove the semicolons from the Name field by replacing them with an empty string. For example, REPLACE (“John;Doe”, “;”, “”) = “JohnDoe”. References: The information is based on the following sources:
* String Functions – Tableau
* Remove special characters and add a semi colon in a word – Tableau

Q41. A Data Analyst needs to update an existing dashboard. The current dashboard shows financial results data, and users have asked for a comparison of budgets to be added to the dashboard. A new data source has been created that includes both the actual costs and budgets and was published to the corporate Tableau site.
How should the analyst update the existing dashboard?

Create a copy of the existing workbook, open it in Tableau Desktop, and connect to the new data source. Update each sheet, using fields from the new data source.

Edit the existing workbook on the Tableau site and connect to the new data source. Blend the new data source with the existing data source.

Create a new workbook in Tableau Desktop and connect to the new data source. Copy and paste all the tabs from the old workbook into the new one.

Edit the existing workbook on the Tableau site and connect to the new data source. From the Data menu, choose Replace Data Source.

Q42. You have the following dataset in Microsoft Excel.

You are using Data interpreter to cleans the dataset. Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

Data interpreter is a feature that helps you clean and structure your data in Excel before importing it into Tableau. It detects and removes any headers, footers, subtotals, or other elements that are not part of the actual data. It also splits any merged cells and fills in any missing values. In this case, data interpreter provides the following results:
It removes the first three rows and the last two rows that contain headers and footers.
It splits the merged cells in column A and fills in the missing values with “Fiction” or “Non-Fiction”.
It does not remove or change any other rows or cells.
Therefore, the number of rows of data that will be ingested into Tableau as values is 17, which is the number of rows left after removing the headers and footers. References:
https://help.tableau.com/current/pro/desktop/en-us/importing_cleaning_up_data.htm
https://help.tableau.com/current/pro/desktop/en-us/importing_data_interpreter.htm Based on the Data Interpreter’s results and the provided Excel dataset screenshot, the number of rows of data that will be ingested into Tableau as values is 17. The Data Interpreter has identified and excluded headers and footers, and the rows with actual data are considered for analysis.

Q43. You want to create the following dashboard that will contain two sheets.

What should you do?

Drag both sheets to the dashboard and add a border to each sheet.

Drag both sheets to the dashboard and add a background lo each sheet.

Add both sheets lo a horizontal container and add a border to the container.

Add a border to both sheets and add both sheets to a horizontal object.

Q44. 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”

Q45. You have the following dataset.

You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?

NAMEUSERNAME()

ISFULLNAMETableu_USER_NAME))=USERNAME()

NAME Tableau-USER-NAME)

USERNAME()=(Tableau_USER_NAME)

Q46. You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00.
You need to ensure that the extract also refreshes on the last day of the month at 18:00.
What should you do?

From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.

From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh

From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month

From Tableau Server. select Schedules and change the priority of the existing schedule

To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules. References:
https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en- us/refresh_extracts_add.htm On Tableau Server, you can manage the scheduling of extract refreshes by selecting the specific workbook and configuring additional refresh schedules as needed. This allows for multiple refresh triggers, such as the regular Monday at 10:00 AM schedule, as well as an additional trigger for the last day of the month at 18:00.

Q47. You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

Image

Sheet

Web page

Horizontal

To add a draft watermark to a dashboard, you should use a sheet as a type of object. A sheet is a worksheet that contains a chart or a table that you can add to your dashboard. You can create a sheet that shows the word “Draft” as a text mark and format it with transparency, size, and color. Then you can drag the sheet to your dashboard and position it behind your other sheets as a floating element. You can also adjust the opacity and layering of the sheet to make it look like a watermark. Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_create_layouts.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_create_watermarks.htm

Q48. You have the following dataset.

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

{FIXED: [Region] SUM Sales}

{FIXED: SUM Sales}

{Fixed: [Region]: TOTAL Sales}

{FIXED: TOTAL (Sales)}

Q49. 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?

Right-click on the measure in the data pane, then click on Create and Calculated Field to convert to a string and add the $ symbol.

Right-click on the measure in the data pane, then click on Default Properties and Number Format.

Click on the Format tab and select Workbook Theme.

Click on the Analysis tab and select Forecast.

Q50. You have the following dataset:
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.

Float

Boolean

Date

Datetime

Chaîne

Integer

In the context of filtering data in Tableau, both string and integer parameters can be used to dynamically filter data. A string parameter can be used to filter text-based values, while an integer parameter is suitable for numerical values. In the provided dataset and result URLs, it appears that a unique identifier or key (which could be a string or integer) is being used to filter specific data entries. References: The information is based on the following sources:
* An Introduction to Parameters in Tableau
* Create Parameters – Tableau

Q51. You have the following data source in tableau Server.

You need to ensure that the data is updated every hour.
What should you select?

Nouveau

Extract Refreshes

Connected Workbooks

Connections

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. References:
https://help.tableau.com/current/server/en-us/refresh_extracts.htm
https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm
To ensure that the data is updated every hour on Tableau Server, you would need to go to the “Extract Refreshes” option. Here, you can schedule the data extracts to refresh at the desired frequency, which in this case would be every hour.

Q52. When using a Show/Hide button in Tableau, what happens if the object is in a Tiled layout container?

The layout automatically adjusts to fill the space.

The object disappears from the item hierarchy.

The hidden object remains in the same position but is grayed out.

The object gets deleted from the dashboard.

Q53. You have the following visualization.

Q54. 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 ?

Q55. 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 ?

Explication :
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. References: 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

Q56. You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

Image

Sheet

Web page

Horizontal

Q57. in which three formats can you export a worksheet from the Worksheet menu? Choose three

.pptx

.csv

.xlsx

.png

.txt

.html

Q58. You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.
The following is a sample of the sales data for me division in Germany.

You have population data in a file named Populatio.csv. the following is a sample of the data.

You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)

Explication :
1) Open Tableau prep
2) Create a new column …
3) Union the sales …
4) Join the sales …
References: https://help.tableau.com/current/prep/en-us/prep_get_started.htm https://help.tableau.com/current
/prep/en-us/prep_union.htm https://help.tableau.com/current/prep/en-us/prep_clean.htm https://help.tableau.
com/current/prep/en-us/prep_join.htm

Q59. You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
* Top N Customers
* Customers of 2020
* Top N Products
* Sellers of 2020
Which two sets can you combine? Choose two

Sellers of 2020

Customers of 2020

Top N Products

Top N Customers

To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined. References:
https://help.tableau.com/current/pro/desktop/en-us/sets.htm
https://help.tableau.com/current/pro/desktop/en-us/sets_create.htm#combine-sets In Tableau, sets can be combined if they are created from the same dimension. From the options provided,
“Customers of 2020” and “Top N Customers” are likely created from the same dimension (Customers).
Therefore, these two sets can be combined to create a new set that includes or excludes members based on the combined criteria. Combining sets like “Top N Products” with “Customers of 2020” would not be feasible unless they are from the same dimension, which is typically not the case.

Q60. You have the following dataset.

You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?

NAMEUSERNAME()

ISFULLNAMETableu_USER_NAME))=USERNAME()

NAME Tableau-USER-NAME)

USERNAME()=(Tableau_USER_NAME)

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”. References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME
https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields.htm In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset.
Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME], which will return true for rows where the Tableau_User_Name matches the current user’s username.

Q61. You have the following chart that shows profits and discounts over time.
You need to combine the lines to appear as shown in the following chart.
What should you do?

Drag Discount to Color on the Marks card

Convert Discount to Discrete

Set Discount to Dual Axis

Drag Discount to the Columns shelf

To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis. Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the menu. This will create two axes on one chart and synchronize their scales.
In this case, you want to show Profit and Discount on two separate axes on one chart. You can right-click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart that shows Profit and Discount as two lines with different colors.
The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will change the color of Profit based on Discount, but it will not show two lines. Converting Discount to Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount, but it will not combine them. References: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures.htm https://help.
tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm

Chargement …

The TDA-C01 exam covers a range of topics related to data analysis, including data connection and preparation, visualization design, dashboard development, and data storytelling. TDA-C01 exam consists of 36 multiple-choice questions that must be completed within 120 minutes. To pass the exam, candidates must demonstrate their knowledge of Tableau Desktop by answering questions related to data analysis best practices, data visualization techniques, and the use of Tableau desktop features and functions. Tableau Certified Data Analyst certification is valid for three years and requires candidates to renew their certification by passing a recertification exam or earning a higher-level Tableau certification.

Updated TDA-C01 Certification Exam Sample Questions: https://www.examboosts.com/Tableau/TDA-C01-practice-exam-dumps.html