Pass Tableau TDA-C01 Exam With Practice Test Questions Dumps Bundle [Q19-Q39]

Pass Tableau TDA-C01 Exam With Practice Test Questions Dumps Bundle

2025 Valid TDA-C01 test answers & Tableau Exam PDF

Tableau TDA-C01 (Tableau Certified Data Analyst) certification exam is an industry-recognized certification that demonstrates proficiency in using Tableau for data analysis and visualization. TDA-C01 exam is designed to test the skills and knowledge required to effectively use Tableau to connect to data, create visualizations, and analyze data. Passing the exam validates that the candidate is well-versed in Tableau and can use the tool to solve real-world data problems.

Tableau TDA-C01 certification exam is an essential credential for professionals seeking to advance their careers in data analysis, business intelligence, and data visualization. It validates their proficiency in using Tableau Desktop to connect, visualize, and share data insights. Tableau Certified Data Analyst certification also provides a practical framework for professionals to develop their skills and stay up-to-date with the latest trends and practices in data analytics and visualization.

 

NEW QUESTION # 19
You have the following:

Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] - 1.
For which three the sub-categories will the value of Rank change? Choose three.

• A. Chairs
• B. Tables
• C. Furnishings
• D. Accessories
• E. Bookcases
• F. Machines
  G Phones
• G. Copiers

Answer: B,D,F

Explanation:
In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
* Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1).
Therefore, its rank remains the same.
* Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
* Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
* Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
* Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
* Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.
* Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2.
Therefore, its rank remains the same.
* Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.

NEW QUESTION # 20
You have a dataset that contains people and the awards they have won.

Which formula should you use to get the number of different types of awards that have been won?

• A. COVAR({Award})
• B. MAX {(Award})
• C. INDEX()
• D. COUNTD {(NAME])
• E. COUNTD({Award})

Answer: D

NEW QUESTION # 21
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

Answer:

Explanation:

1 - Aggregate the date to month and year.
2 - Create a calculated field that uses the MODEL_QUANTILE function.
3 - Add the date to the Columns sfelf. Add the segment and the sales to the Rows shelf.

NEW QUESTION # 22
You are developing a data source in Tableau Prep.
You have two tables named Orders and Employees.
The Orders table was created in 2019 and contains the following columns.
The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns You want to prepare the data so that you can analyze sales trends over time for every sales team.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area. Use Answer Area arrows to re-order the options.)

Answer:

Explanation:
There are different ways to prepare the data in Tableau Prep, but one possible answer is:
Answer area:
* Join the tables.
* Aggregate the data by Sales Team.
* Add the following filter to the Employees table: Sale Team - Team Alpha.
To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.
References:
[Tableau Certified Data Analyst Exam Prep Guide], page 9, section "Preparing Data"
[Tableau Help: Join Your Data]
[Tableau Help: Aggregate Your Data]
[Tableau Help: Filter Your Data]

NEW QUESTION # 23
You have the following dataset:

Which grouping option should you use in Tableau Prep to group all five names automatically?

• A. Pronunciation
• B. Manual Selection
• C. Common Characters
• D. Spelling

Answer: C

Explanation:
Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as "John Smith" and "Smith, John" because they both generate the key "hijmnost". Since this algorithm doesn't consider pronunciation, the value "Tom Jhinois" would have the same key "hijmnost" and would also be included in the group.

NEW QUESTION # 24
You have the following:
Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] - 1.
For which three the sub-categories will the value of Rank change? Choose three.

• A. Chairs
• B. Tables
• C. Furnishings
• D. Accessories
• E. Bookcases
• F. Machines
  G Phones
• G. Copiers

Answer: B,D,F

Explanation:
In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1). Therefore, its rank remains the same.
Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.
Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2. Therefore, its rank remains the same.
Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.

NEW QUESTION # 25
You have the following dataset.


When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.

What should you do?

• A. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
• B. Change the data type of the Sates field to Siring
• C. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
• D. Change the default number format of the Sales told

Answer: D

Explanation:
To make Sales appear automatically as shown in the second table, you should change the default number format of the Sales field. The default number format is how Tableau displays a field when you drag it to a worksheet. You can change the default number format by right-clicking on the field and selecting Default Properties > Number Format from the menu. This will open a dialog box where you can choose a category, such as Currency or Percentage, and customize the options, such as decimal places or prefixes.
In this case, you want to change the default number format of Sales to Currency with zero decimal places and a custom prefix of "S". This will make Sales appear as "S" followed by the rounded value in thousands.
The other options are not correct for this scenario. Changing the data type of Sales to String will not affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change the default number format of Sales, but create a new field that you have to drag to a worksheet. Converting Sales to Attribute will return only one value for each partition of data, which will not show any variation over time. Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_change_default.htm

NEW QUESTION # 26
Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.

• A. Send us your feedback on it.
• B. Send us your

Answer: A

NEW QUESTION # 27
You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.
You create several filters.
From the Data Source page you plan to add data source fillers
When type of filter will appear in the Edit Data Source Filters dialog box?

• A. A context filler on a dimension m Sheet3
• B. A top N condition filer on a dimension in Sheet 1 and Sheet2
• C. A table calculation filter used on Sheet
• D. A dimension Maw on all the sheets

Answer: B

NEW QUESTION # 28
You have the following dashboard.
Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table What should you do?

• A. From the context menu of Profits by Stale deselect Use as Filter
• B. From the context menu of Sales over time select Ignore Actions
• C. From the context menu of Sales over time select Deselect
• D. From the context menu of Sales over lime select Remove Dashboard Item

Answer: B

Explanation:
To configure the dashboard to ensure that selecting a data point on the map only filters the Detail table, you should select Ignore Actions from the context menu of Sales over time. Ignore Actions is a feature that allows you to exclude a sheet from being affected by any actions on the dashboard, such as filters or highlights. You can select Ignore Actions by right-clicking on a sheet on the dashboard and selecting Ignore Actions from the menu.
In this case, you want to exclude Sales over time from being filtered by the map, so you should select Ignore Actions from its context menu. This will make Sales over time ignore any selections on the map and show all values. The Detail table will still be filtered by the map as usual.
The other options are not correct for this scenario. Removing Dashboard Item will delete Sales over time from the dashboard, which is not what you want. Deselecting Use as Filter will disable the map as a filter for any sheet on the dashboard, which is not what you want. Selecting Deselect will clear any selections on the map, but it will not prevent Sales over time from being filtered by future selections. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_ignore.
htm
On a Tableau dashboard, when a map is used as a filter, it affects all other sheets in the dashboard by default.
To restrict the filter action to only affect the Detail table and not the 'Sales over time' chart, you would modify the action settings. By selecting "Ignore Actions" from the context menu of the 'Sales over time' chart, it will no longer respond to the filtering action initiated by selecting data points on the map.

NEW QUESTION # 29
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.
You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?

• A. Right-click a bar in the chart select Mark Label and then select Always show.
• B. Right-click a in the chat, select Annotate and then select Mark.
• C. Drag Region to Tooltip on the Marks card
• D. Edit the aliases for City.

Answer: C

Explanation:
To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.
com/current/pro/desktop/en-us/formatting_tooltips.htm
To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the 'Region' field to the 'Tooltip' shelf on the 'Marks' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.

NEW QUESTION # 30
You have the Mowing two tables that contains data about the books in a library.


Both tables are incomplete so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?

• A. left join
• B. Full outer join
• C. Inner join
• D. Right join

Answer: C

NEW QUESTION # 31
You have the following dataset that contain null values in the Profits field.

You want the data to appear as shown in the following table.

Which two formulas achieve the goal? Choose two.

• A. IFNULL [(profits] ,0)
• B. IF [Profits] != null then [Profits] END
• C. IFNULL([Profits],0) D. IF [Profits] != null then [Profits] END
• D. ISNULL ([Profits])
• E. 2N ([Profits])

Answer: A,E

Explanation:
The IFNULL function is a logical function that returns the first argument if it is not null, and the second argument if it is null. In this case, the first argument is [Profits], which is the field that contains null values. The second argument is 0, which is the value that you want to replace null values with. The function will return [Profits] if it is not null, and 0 if it is null.
The IF statement is a logical statement that returns a value or performs an action if a condition is true, and optionally returns another value or performs another action if the condition is false. In this case, the condition is [Profits] != null, which means that [Profits] is not null. The statement will return [Profits] if the condition is true, and nothing if the condition is false. The END keyword marks the end of the statement.
The other options are not correct for this scenario. The ZN function is a logical function that returns zero if a value or expression is null, and returns the value or expression itself if it is not null. However, it only works with numeric values or expressions, and [Profits] may not be numeric in this case. The ISNULL function is a logical function that returns TRUE if a value or expression is null, and FALSE otherwise. It does not replace null values with another value. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL Explanation:
The two formulas that will make the data appear as shown in the second table are:

NEW QUESTION # 32
You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.

• A. The data source must use a live connection.
• B. The credentials must be embedded.
• C. The data must be extracted.
• D. The data source must be stored as a hyper file.

Answer: B,C

NEW QUESTION # 33
You have the following dashboard.

When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

Answer:

Explanation:

Explanation:
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. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_filter.htm

NEW QUESTION # 34
A Data Analyst needs to calculate the percent of regional sales that each state contributes to. As a first step, the analyst needs to calculate total sales per region.
Which calculation should the analyst use to do this?

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

Answer: C

NEW QUESTION # 35
You have the following visualization.

You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: A

Explanation:
To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.
Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):
Student ID 4183: 39 (Rank 1)
Student ID 4220: 71 (Rank 6)
Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank) Student ID 4124: 75.5 Student ID 4050: 64 Student ID 4205: 67 Student ID 4056: 66 Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.
Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.
https://help.tableau.com/current/prep/en-us/prep_calculations.htm

NEW QUESTION # 36
You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?

Answer:

Explanation:

Explanation:
Replace Data Source
Replace Data Source is a feature that allows you to replace one data source with another one that has the same or similar fields and structure. It updates all the worksheets that use the original data source with the new one, without reloading the data. In this case, you want to replace the data source that contains order data from 2019 with the one that contains order data from 2020.
To replace the data source, you need to do the following steps:
Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the original data source.
Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.
Select the data source that contains order data from 2020 from the list of available data sources and click OK. This will replace your original data source with the new one and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_replace.htm
https://help.tableau.com/current/pro/desktop/en-us/datasource_replace_workbook.htm

NEW QUESTION # 37
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?

• A. (SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
• B. (SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
• C. (SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))
• D. (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )

Answer: B

Explanation:
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. References:
* LOOKUP Function - Tableau
* Table Calculations - Tableau
* Tableau Certified Data Analyst Study Guide

NEW QUESTION # 38
Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.

Answer:

Explanation:
Send us your feedback on it

NEW QUESTION # 39
......

Tableau TDA-C01 certification exam is conducted by Tableau, Inc., a leading technology company that specializes in data visualization and business intelligence solutions. Tableau Certified Data Analyst certification exam is designed to assess the candidate's ability to analyze data, create visualizations, and develop dashboards using Tableau products. TDA-C01 exam is conducted online, and candidates can take it from anywhere in the world.

 

Top Tableau TDA-C01 Courses Online: https://passleader.realexamfree.com/TDA-C01-real-exam-dumps.html