Home / Tableau / TDA-C01

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

Question list

List of questions

Question 101

(0)

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

Question 102

(0)

Refer to the exhibit. You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically. What should you do?

Question 103

(0)

You plan to create a Tableau subscription for several users. Which two formats can you use? Choose two.

Question 104

(0)

HOTSPOT You have the following worksheet.

Question 105

(0)

You want to show the cumulative total of each year for every state. Which quick table calculation should you use?

Question 106

(0)

You have a dashboard that contains a parameter named Start Date. You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date. What should you do?

Question 107

(0)

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

Question 108

(0)

HOTSPOT You use a quick table calculation lo calculate the moving average of a measure named Sales. You need to calculate the moving averages of the last three years. Which setting should you cha

Question 109

(0)

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database. You plan to publish

Question 110

(0)

You have the following view. You want to filter the view lo show only records that have a movie name starting with the word. 'The'. You must achieve the goal without writing any formulas. Which

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?

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

Question 101

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

Show Answer Comment (0)

Question 102

Refer to the exhibit.

You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.

What should you do?

Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.

Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.

Select the top 10 bars, and then change the color by selecting Color on the Marks card.

Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.

Show Answer Comment (0)

Question 103

You plan to create a Tableau subscription for several users.

Which two formats can you use? Choose two.

PDF

Image

Microsoft Excel

Microsoft PowerPoint

Show Answer Comment (0)

Question 104

HOTSPOT

You have the following worksheet.

Show Answer Comment (0)

Question 105

You want to show the cumulative total of each year for every state.

Which quick table calculation should you use?

VTD Growth

Running Total

Year Over Year Growth

YTD Total

Show Answer Comment (0)

Question 106

You have a dashboard that contains a parameter named Start Date.

You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.

What should you do?

Create a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.

Create a custom SOL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.

Create a custom SOL query that references Stan Date in the WHERE clause.

Create a data source based on the Excel worksheet and create a calculated field based on Start Date. From the Data pane, add the calculated field to the data source filter

Show Answer Comment (0)

Question 107

HOTSPOT

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

Show Answer Comment (0)

Question 108

HOTSPOT

You use a quick table calculation lo calculate the moving average of a measure named Sales.

You need to calculate the moving averages of the last three years.

Which setting should you change in the Table Calculation dialog box? {Click the appropriate Option in the Answer Area)

Show Answer Comment (0)

Question 109

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.

You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.

What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.

Change the data source to an extract before you publish.

Embed the credentials when you publish the workbook.

Remove all the data source filters before you publish.

Export the data to a .csv before you publish.

Configure the local file permissions to the workbook file, and then publish the workbook.

Show Answer Comment (0)

Question 110

You have the following view.

You want to filter the view lo show only records that have a movie name starting with the word. 'The'. You must achieve the goal without writing any formulas.

Which type of filter should you use?

Wildcard

Condition

General

Top

Show Answer Comment (0)

Total 120 questions

8 9 10 11 12

Go to page: of 12