[2024] Pass TDA-C01 Exam - Real Questions and Answers TDA-C01 Exam Questions Get Updated [2024] with Correct Answers Tableau TDA-C01 Certification Exam is a rigorous and comprehensive certification program for professionals who want to validate their skills in data analysis and visualization using the Tableau platform. Tableau Certified Data Analyst certification exam covers a wide range of topics [...]

All Products Contact now

[2024] Pass TDA-C01 Exam - Real Questions & Answers [Q73-Q96]

Share

[2024] Pass TDA-C01 Exam - Real Questions and Answers

TDA-C01 Exam Questions Get Updated [2024] with Correct Answers


Tableau TDA-C01 Certification Exam is a rigorous and comprehensive certification program for professionals who want to validate their skills in data analysis and visualization using the Tableau platform. Tableau Certified Data Analyst certification exam covers a wide range of topics and requires candidates to have a good understanding of data analysis concepts, data visualization best practices, and the Tableau platform. Tableau Certified Data Analyst certification is a valuable credential for professionals who want to advance their careers in data analysis and visualization and can provide a competitive edge in the job market.

 

NEW QUESTION # 73
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 # 74
You have the following data source in tableau Server.

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

  • A. New
  • B. Connections
  • C. Extract Refreshes
  • D. Connected Workbooks

Answer: C


NEW QUESTION # 75
You have the following dataset:

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

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

Answer: A

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 # 76
You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

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

Answer: A

Explanation:
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


NEW QUESTION # 77
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. IFNULL [(profits] ,0)
  • C. IF [Profits] != null then [Profits] END
  • D. ISNULL ([Profits])
  • E. 2N ([Profits])

Answer: B,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 # 78
You have a data source that contains the following columns.

You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
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:

1 - Create an integer data type parameter named Param1
2 - Drag Region to the Filters shelf.
3 - Configure a Top filter by field. Use Param1 and filter by the sum of Sales.
Reference:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Filtering Data" Tableau Help: Parameters Tableau Help: Top Filters


NEW QUESTION # 79
You have the following visualization.

The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

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

Answer: C

Explanation:
The LAST() function in Tableau returns the number of rows from the current row to the last row in the partition. When you compute using 'Order Date', it will change the partitioning of the calculation. If
'Consumer' in '2018' is the last row in its partition when computed by 'Order Date', then LAST() will return 0 for that cell.
The LAST() function in Tableau is a table calculation that returns the number of rows from the current row to the last row in the partition. The value of LAST() is 0 for the last row, increases by 1 for each row above the last row, and can be negative for rows below the current row if there are such rows in the partition.
In the provided visualization, LAST() is set to compute using Table (across). Changing the compute mode to use "Order Date" will adjust the partitioning of the data upon which the LAST() function is calculated. Since
"Order Date" is likely to be a unique value per row (assuming each order has a unique date), each row becomes its own partition.
For the Consumer segment of the year 2018, if "Order Date" is unique for each row, then the last row in each partition (in this case, each individual row) will have a LAST() value of 0 because there are no other rows in the partition - it's the last row of its own partition.
Therefore, when you change the compute mode of LAST() to use "Order Date", each cell under the Consumer segment for the year 2018 will have the LAST() value of 0, because each order date creates a partition of one, making every row the last in its partition.


NEW QUESTION # 80
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. Inner join
  • B. Full outer join
  • C. Right join
  • D. left join

Answer: A


NEW QUESTION # 81
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?

  • A. From the Data menu select New Data Source
  • B. From the File menu select New
  • C. From the Data menu select Replace Data Source
  • D. From the File menu select Import Workbook

Answer: A

Explanation:
To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. Reference: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm


NEW QUESTION # 82
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.

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

Answer: B


NEW QUESTION # 83
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 shelf Add the segment and the sales to the Rows shelf


NEW QUESTION # 84
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. (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )
  • D. (SUM ([Sales]) - LOOKUP (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. Reference:
LOOKUP Function - Tableau
Table Calculations - Tableau
Tableau Certified Data Analyst Study Guide


NEW QUESTION # 85
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. check the steps below in explanation

Answer: A

Explanation:
To add the Sales by State sheet in a Show/Hide button to the right side of the dashboard, 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 sales dashboard.
Click on the sales dashboard tab at the bottom of the workbook to open the dashboard. You will see a dashboard that shows various charts and filters related to sales data.
Drag Sales by State from the Sheets pane to the right side of the dashboard. This will add the sheet as a floating element on the dashboard. You can resize and position it as you like.
Right-click on Sales by State and select Add Show/Hide Button from the menu. This will add a button that allows you to show or hide the sheet on the dashboard. You can customize the appearance and behavior of the button by clicking on it and using the options on the Marks card.
Optionally, you can drag a vertical layout container from the Objects pane to the right side of the dashboard and place Sales by State and its button inside it. This will help you organize your dashboard elements and align them neatly.


NEW QUESTION # 86
You have the following table.

You need each record to alternate between grey and white.
What should you change in the Format Shading pane?

  • A. the column banding size to 1
  • B. the row banding size to 3
  • C. the row banding size to 1
  • D. the column banding size to 3

Answer: C

Explanation:
To have each record alternate between grey and white, you should change the row banding size to 1 in the Format Shading pane. This setting will ensure that each row has a different shading from the one above and below it, creating an alternating pattern of grey and white rows. References: The answer can be verified through practical application within Tableau or by consulting Tableau's official learning resources, such as Tableau Help: Format Shading or Tableau Training Pass: Formatting.


NEW QUESTION # 87
You want to create the following dashboard.

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

  • A. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
  • B. Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
  • C. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
  • D. Add both sheets to the dashboard. Set Fit to Fix width.

Answer: A

Explanation:
To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. Reference:
Size and Lay Out Your Dashboard - Tableau
Create a Dashboard - Tableau
Format Dashboard Layout in Tableau - GeeksforGeeks


NEW QUESTION # 88
You have the following dataset.

You need to create the following worksheet.

The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

Answer:

Explanation:

Explanation:
A screenshot of a computer Description automatically generated


NEW QUESTION # 89
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?

  • A. From the Server menu, select Tableau Public, and then select Save to Tableau Public.
  • B. From the File menu, select Export Packaged Workbook.
  • C. From the Server menu, select Publish Workbook.
  • D. From the Server menu, select Publish Data Source.

Answer: C


NEW QUESTION # 90
You have the following dataset.

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

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

Answer: B


NEW QUESTION # 91
You want to create the following dashboard.

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

  • A. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
  • B. Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
  • C. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
  • D. Add both sheets to the dashboard. Set Fit to Fix width.

Answer: A

Explanation:
To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. References:
Size and Lay Out Your Dashboard - Tableau
Create a Dashboard - Tableau
Format Dashboard Layout in Tableau - GeeksforGeeks


NEW QUESTION # 92
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.

Answer:

Explanation:
check the steps below in explanation.
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.
References: 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/en-us/calculations_tablecalculations_percentoftotal.htm


NEW QUESTION # 93
You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.
What should you do?

  • A. From the context menu of Sheet3, select Deselect.
  • B. Right-click Sheet2 and select Add to Dashboard.
  • C. Drag Sheet2 to the dashboard.
  • D. From the context menu of Sheet3, select Remove Dashboard Item.
  • E. Select Sheet3 and click the Swap Sheet button next to Sheet2.

Answer: E

Explanation:
Reference:
Create a Dashboard - Tableau
Tableau Certified Data Analyst Study Guide


NEW QUESTION # 94
You need to change the values of a dimension without creating a new field.
What should you do?

  • A. Rename the fields
  • B. Create groups
  • C. Transforms the fields
  • D. Create aliases

Answer: D

Explanation:
You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for "Central" as "Midwest".
In Tableau, aliases can be used to change the way dimension members appear without altering the underlying data. This is useful for display purposes and does not create a new field within the dataset.


NEW QUESTION # 95
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: B

Explanation:
the rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.
To answer your question, we need to apply the rank function to the Avg Score column and sort it in descending order. Then we can find the rank score value for Student ID 4220 by looking at the corresponding row.
Here is how the table would look like after applying the rank function and sorting:

As you can see, the rank score value for Student ID 4220 is 1.


NEW QUESTION # 96
......


The Tableau TDA-C01 exam covers a wide range of topics, including data connections, data visualization, calculations, mapping, and data analysis. Candidates are expected to have a solid understanding of data analysis techniques and be able to use Tableau software to create interactive dashboards and reports that effectively communicate insights from data. TDA-C01 exam also assesses candidates' ability to manipulate data using Tableau Prep, a tool that allows users to clean, reshape, and combine data from multiple sources.


The TDA-C01 exam consists of 36 multiple-choice questions that must be completed within 120 minutes. TDA-C01 exam covers various topics such as data connection, data preparation, data analysis, and data visualization. Tableau Certified Data Analyst certification exam assesses the candidate's ability to use Tableau Desktop to create and publish interactive visualizations, perform calculations, and solve real-world data problems. The Tableau TDA-C01 certification is a valuable credential for data analysts who want to advance their career by demonstrating their proficiency in Tableau data analysis and visualization.

 

Practice TDA-C01 Questions With Certification guide Q&A from Training Expert GuideTorrent: https://lead2pass.guidetorrent.com/TDA-C01-dumps-questions.html

Related Articles

more
Tableau TDA-C01 Certification Practice Exam