Read Online TDA-C01 Test Practice Test Questions Exam Dumps
Easily To Pass New TDA-C01 Premium Exam Updated [Feb 19, 2025]
The TDA-C01 exam consists of 36 multiple-choice questions that are designed to test the candidate's knowledge of Tableau products and their ability to apply that knowledge to real-world scenarios. TDA-C01 exam is timed, with a maximum of 120 minutes allowed for completion, and candidates must achieve a passing score of 75% or higher to earn the certification. TDA-C01 exam covers a range of topics, including data connections and preparation, data analysis, visualizations, and dashboard creation and sharing. Tableau Certified Data Analyst certification is valid for two years and can be renewed by passing a recertification exam or completing continuing education requirements.
Tableau TDA-C01 exam is designed to test the knowledge and skills of individuals who want to become certified Tableau data analysts. Tableau Certified Data Analyst certification demonstrates the ability to use Tableau software to analyze data and create visualizations that aid decision-making processes. TDA-C01 exam is ideal for individuals who work with data on a regular basis and want to showcase their proficiency in using Tableau to derive insights from it.
NEW QUESTION # 54
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.
Answer:
Explanation:
Explanation:
Sales: B. Columns
Profit: D. Rows
Customer Name: C. Detail on the Marks card
Category: A. Color on the Marks card
To create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm
https://help.tableau.com/current/pro/desktop/en-us/buildexamples_scatter.htm
NEW QUESTION # 55
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.
- A. Send us your
- B. Send us your feedback on it.
Answer: B
NEW QUESTION # 56
You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
- A. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
- B. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- C. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End - D. IF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END
Answer: C,D
Explanation:
To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects. References:
Logical Functions - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 57
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?
- A. Change Population to a discrete dimension
- B. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
- C. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
- D. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
Answer: B
Explanation:
To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu. References:
https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm
https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_size.htm In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.
NEW QUESTION # 58
You have a table that contains four columns named Order Date, Country, Sales, and Profit.
You need to add a column that shows the day of the week for each row. For example, orders placed on August
31, 2022, will show a day of
Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
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.
References:
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.
References:
Tableau Help: DATENAME Function
Tableau Help: Date Functions
NEW QUESTION # 59
You create the following worksheet
The Pick Measure parameter contains the following list of values
Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the Selected Measure calculated field lo switch between measures?
- A. Case [Pick Measure]
WHEN 1 then ([Sales])
WHEN 2 then ([Profit])
END - B. Case [Pick Measure:
WHEN [Sales] then 1
WHEN [Profit] then 2 END - C. Case AVG([Pick Measure])
WHEN [Sales] then 1
WHEN [Profit] then 2
END - D. Case STFMEPick Measure])
WHEN "Sales" then ([Sales])
WHEN "Profit" then ([Profit]) e::i
Answer: A
Explanation:
https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm
This formula uses a parameter (Pick Measure) to switch between the Sales and Profit measures. When the user selects '1', it shows Sales, and when '2' is selected, it shows Profit. This dynamic switching is enabled by the Case function.
NEW QUESTION # 60
You have the following dataset
You need to create the following visualization.
Which quick table calculation should you drag to Text on the Marks card?
- A. Percent Difference
- B. Compound Growth Rate
- C. Percentile
- D. Percent of Total
Answer: D
Explanation:
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:
NEW QUESTION # 61
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. check the steps below in explanation
Answer: A
Explanation:
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.
NEW QUESTION # 62
You have the following dataset.
You need to generate the results in the Day field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
NEW QUESTION # 63
You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
- A. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
- B. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- C. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities' - D. IF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END
Answer: C,D
Explanation:
End
Explanation:
To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects. Reference:
Logical Functions - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 64
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 65
You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers How should you share me dashboard with the healthcare workers?
- A. Print the dashboard to PDF
- B. Publish aw dashboard to Tableau Server
- C. Export the dashboard as a .twbx
- D. Publish the dashboard to Tableau Public
Answer: B
Explanation:
To share a dashboard that contains confidential information about patients health and needs to always be up to date for a team of healthcare workers, you should publish it to Tableau Server. This will allow you to control who can access and interact with your dashboard, as well as schedule automatic refreshes of your data source or extract. Publishing to Tableau Public would expose your data to anyone on the internet, printing to PDF would not update your data, and exporting as a .twbx would require sending a large file that might not be compatible with other versions of Tableau. Reference: https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_share.htm https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_tableauserver.htm
NEW QUESTION # 66
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. Full outer join
- B. Inner join
- C. left join
- D. Right join
Answer: A
Explanation:
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. References:
https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm
https://help.tableau.com/current/pro/desktop/en-us/join_types.htm
When combining two datasets that are both incomplete and where it's important to retain all data from both sources, a full outer join is appropriate. This type of join ensures that all records from both tables are included in the combined dataset, even if there are no matching records in the other table.
NEW QUESTION # 67
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. Copiers
- B. Tables
- C. Machines
G Phones - D. Chairs
- E. Accessories
- F. Furnishings
- G. Bookcases
Answer: B,C,E
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 # 68
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 default number format of the Sales told
- C. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
- D. Change the data type of the Sates field to Siring
Answer: B
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 # 69
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 70
You have the following box plot that shows the distribution of average profits made in every state by region.
Which region has the smallest distribution of profits?
- A. Central
- B. Cast
- C. South
- D. West
Answer: C
Explanation:
The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.
NEW QUESTION # 71
You have the following line chart that shows the average sales by month.
Which month had the biggest increase in swage sales compared to me previous month in 2019?
- A. October
- B. December
- C. August
- D. November
Answer: A
NEW QUESTION # 72
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:
NEW QUESTION # 73
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.
You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
- A. Condition filter
- B. Wildcard filter
- C. General filter
- D. Top filter
Answer: A
Explanation:
To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition.
In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.
The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation. Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 74
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:
NEW QUESTION # 75
You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
You want to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do NOT match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should you use?
- A. Inner
- B. Left
- C. Left only
- D. Full outer
- E. Union
Answer: C
Explanation:
To combine the tables by using Tableau Prep and include only values from Table1 that do not match any values in Table2, you should use a left only join. A left only join is a type of join that returns only the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2). The field values from Table2 will appear as null values in the combined table. A left only join is also known as an anti-join or an exclusion join. Reference:
Tableau Certified Data Analyst Exam Prep Guide, page 9, section "Preparing Data" Tableau Help: Join Your Data Tableau Help: Left Only Join
NEW QUESTION # 76
You have a dataset that contains sates dat
a. The following is a sample of the data.
You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two
- A. SUM{[Sales]) IN (50000)
- B. [Sales] > 50000
- C. MAX< [Sales], 50000)
- D. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
Answer: B,D
NEW QUESTION # 77
You have the following visualization.
You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:
IF FIRST () = 0 THEN COUNT (Returns) END
This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.
To complete the formula in the calculated field, you should select the following options from the drop-down menus:
FIRST ()
0
COUNT (Returns)
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm
NEW QUESTION # 78
......
Tableau TDA-C01 exam covers a wide range of topics related to data analysis, including data preparation, data analysis, and data visualization. It also includes questions on Tableau’s features and functionality, as well as best practices for using the software effectively. TDA-C01 exam consists of multiple-choice questions and is timed at 120 minutes. A passing score of 75% or higher is required to obtain the Tableau Certified Data Analyst certification.
TDA-C01 Certification All-in-One Exam Guide Feb-2025: https://www.vcetorrent.com/TDA-C01-valid-vce-torrent.html
Get Real TDA-C01 Exam Dumps [Feb-2025] Practice Tests: https://drive.google.com/open?id=1g8AOdSZlaiwVxsL5h4DZmsKFvIpol8ZU