Home / Tableau / TDA-C01

Tableau TDA-C01 Practice Test - Questions Answers, Page 9

Question list

List of questions

Question 81

(0)

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

Question 82

(0)

HOTSPOT 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 th

Question 83

(0)

HOTSPOT You have the following visualization.

Question 84

(0)

HOTSPOT 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''

Question 85

(0)

HOTSPOT 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

Question 86

(0)

HOTSPOT You have a dashboard than contains two sheets named Sheet 1 and Sheet 2. You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.

Question 87

(0)

DRAG DROP 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 St

Question 88

(0)

DRAG DROP 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

Question 89

(0)

DRAG DROP You conned to a Microsoft SQL Server database You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned H

Question 90

(0)

DRAG DROP 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

Related questions

You want to create the following dashboard that will contain two sheets. What should you do?

HOTSPOT You have a data set that contains three columns named Sales, Profit, and Quantity. You need to build the following scatter plot.

You have the following dashboard. From the context menu of Sales over time, select Ignore Actions. Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map. What should you do?

DRAG DROP In a worksheet, you have a calculated column named YTD Sales that uses the following formula. [Order Date] <= TODAY () AND DATETBUNC {''year'', [Order Dace]) = DATETPUNC)'year', TODAY(J) You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales. How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

You want to create the following table in a view. Which function should you use to create the Position column?

DRAG DROP You conned to a Microsoft SQL Server database You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

In a dataset, you have a string field named Name that contains unnecessary semicolons. Which function should you use to remove the semicolons from the Name field?

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

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?

DRAG DROP 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)

Question 81

HOTSPOT

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

Show Answer Comment (0)

Question 82

HOTSPOT

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?

Show Answer Comment (0)

Question 83

HOTSPOT

You have the following visualization.

Show Answer Comment (0)

Question 84

HOTSPOT

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''

Show Answer Comment (0)

Question 85

HOTSPOT

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

Show Answer Comment (0)

Question 86

HOTSPOT

You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.

You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.

Which object should you add to the dashboard?

Show Answer Comment (0)

Question 87

DRAG DROP

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)

Show Answer Comment (0)

Question 88

DRAG DROP

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)

Show Answer Comment (0)

Question 89

DRAG DROP

You conned to a Microsoft SQL Server database

You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned

How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Show Answer Comment (0)

Question 90

DRAG DROP

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

Show Answer Comment (0)

Total 120 questions

7 8 9 10 11

Go to page: of 12