[Jan-2023] Download Real Tableau TDA-C01 Exam Dumps Test Engine Exam Questions [Q10-Q33]

4.5/5 - (2 votes)

[Jan-2023] Download Real Tableau TDA-C01 Exam Dumps Test Engine Exam Questions

New TDA-C01 exam dumps Use Updated Tableau Exam

Q10. You have the following dataset.

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

{FIXED: [Region] SUM Sales}

{FIXED: SUM Sales}

{Fixed: [Region]: TOTAL Sales}

{FIXED: TOTAL (Sales)}

Q11. 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%.

Q12. You have the following dataset.

Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?

Q13. 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

SUM{[Sales]) IN (50000)

IIF(SUM< [Sales] )>50000, TRUE, FALSE)

MAX< [Sales], 50000)

[Sales] > 50000

Q14. You have the following tiled dashboard that has one sheet.

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

Right-click Sheet2 and select Add to Dashboard.

Select Sheets and click the Swap Sheet button next to Sheet2.

From the context menu of Sheet3. select Remove Dashboard item

Drag Sheet2 to the dashboard.

From the context menu of Sheet3. select Deselect

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

The following is a sample of the sales data for me division in Germany.

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

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

Q16. From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?

All the data sources published to the site

All the data sources published to the Tableau Server

All the data sources published to the site within the folders to which you have access

All the data sources published to the Tableau Server within the folders to which you have access

Q17. 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.

2N ([Profits])

ISNULL ([Profits])

IFNULL [(profits] ,0)

IF [Profits] != null then [Profits] END

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

Publish the dashboard to Tableau Public

Print the dashboard to PDF

Publish aw dashboard to Tableau Server

Export the dashboard as a .twbx

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

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

August

October

December

November

Q21. 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.)

Q22. 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.

Send us your feedback on it.

Send us your

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

From the Data menu select New Data Source

From the Data menu select Replace Data Source

From the File menu select Import Workbook

From the File menu select New

Q24. 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.

Send us your feedback on it.

Send us your

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

The following is a sample of the sales data for me division in Germany.

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

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

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

August

October

December

November

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

.pptx

.csv

.xlsx

.png

.txt

.html

Q28. 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.

Q29. 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.)

Q30. You have the following dataset.

Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?

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

From the context menu of Sales over time select Ignore Actions

From the context menu of Sales over lime select Remove Dashboard Item

From the context menu of Profits by Stale deselect Use as Filter

From the context menu of Sales over time select Deselect

Q32. You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

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