[Sep 10, 2023] Genuine TDA-C01 Exam Dumps New 2023 Tableau Pratice Exam [Q21-Q42]

[Sep 10, 2023] Genuine TDA-C01 Exam Dumps New 2023 Tableau Pratice Exam

New 2023 Realistic TDA-C01 Dumps Test Engine Exam Questions in here

Tableau TDA-C01 (Tableau Certified Data Analyst) Certification Exam is an industry-recognized certification program offered by Tableau, one of the leading data visualization software providers in the world. Tableau Certified Data Analyst certification is designed for professionals who want to validate their skills in data analysis using Tableau, and it is aimed at data analysts, business analysts, and other professionals who want to demonstrate their proficiency in data visualization and analysis.

NEW QUESTION # 21
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''

Answer:

Explanation:

NEW QUESTION # 22
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

Answer:

Explanation:
check the steps below in explanation
Explanation:
To split the Customer Name field into two fields named First Name and Last Name, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
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 Superstore data source.
Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table.
Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name.
Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.

NEW QUESTION # 23
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 # 24
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. COUNTD({Award})
B. MAX {(Award})
C. COUNTD {(NAME])
D. INDEX()
E. COVAR({Award})

Answer: A

Explanation:
To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.
The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau. MAX({Award}) will return the maximum value in the Award field, which may not be a type of award. INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#INDEX

NEW QUESTION # 25
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 # 26
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 # 27
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' + stri < (Sales)/1000)).
B. Change the default number format of the Sales told
C. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
D. Change the data type of the Sates field to Siring

Answer: D

NEW QUESTION # 28
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: D

Explanation:
The value that will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Order Date is 0. The Last() calculation is a table calculation that returns the number of rows from the current row to the last row in the partition. The partition is determined by how you compute the calculation. In this case, you change compute to use Order Date, which means that the calculation will be performed for each value of Order Date.
The crosstab shows that there are two values of Order Date for the Consumer segment of the year 2018: Q1 and Q4. The Last() calculation will return 0 for Q4, because it is the last row in the partition. It will return 1 for Q1, because it is one row away from the last row in the partition.
The other options are not correct for this scenario. The Last() calculation will not return 2, 3, or 4 for any value of Order Date, because there are only two values in each partition.

NEW QUESTION # 29
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:
check the steps below in explanation
Explanation:
To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a # sign next to it.
Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.

NEW QUESTION # 30
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. Send us your
B. Send us your feedback on it.

Answer: B

NEW QUESTION # 31
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]: TOTAL Sales}
B. {FIXED: TOTAL (Sales)}
C. {FIXED: SUM Sales}
D. {FIXED: [Region] SUM Sales}

Answer: A

NEW QUESTION # 32
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. Extract Refreshes
B. Connections
C. Connected Workbooks
D. New

Answer: A

Explanation:
To ensure that the data is updated every hour, you need to select Extract Refreshes from the data source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an existing one. You can specify the frequency and time of the refresh, as well as any custom options or credentials. New will create a new data source, Connected Workbooks will show you which workbooks use this data source, and Connections will show you which tables or files are connected to this data source. Reference: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

NEW QUESTION # 33
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 Sales over time select Ignore Actions
B. From the context menu of Sales over time select Deselect
C. From the context menu of Sales over lime select Remove Dashboard Item
D. From the context menu of Profits by Stale deselect Use as Filter

Answer: A

NEW QUESTION # 34
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. Pronunciation
D. Common Characters

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 # 35
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 dimension Maw on all the sheets
B. A top N condition filer on a dimension in Sheet 1 and Sheet2
C. A context filler on a dimension m Sheet3
D. A table calculation filter used on Sheet

Answer: B

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

NEW QUESTION # 37
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. Extract Refreshes
B. Connections
C. Connected Workbooks
D. New

Answer: A

NEW QUESTION # 38
You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

A. Sheet
B. Horizontal
C. Image
D. Web page

Answer: A

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

NEW QUESTION # 39
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 # 40
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.

Answer:

Explanation:
check the steps below in explanation
Explanation:
To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet.
Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source.
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 existing 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 Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.

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