Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

TDA-C01 Questions and Answers

Question # 6

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?

A.

Publish the dashboard to Tableau Public

B.

Print the dashboard to PDF

C.

Publish the dashboard to Tableau Server

D.

Export the dashboard as a .twbx

Full Access
Question # 7

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: SUM Sales}

C.

{Fixed: [Region]: TOTAL Sales}

D.

{FIXED: TOTAL (Sales)}

Full Access
Question # 8

You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00.

You need to ensure that the extract also refreshes on the last day of the month at 18:00.

What should you do?

A.

From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.

B.

From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh

C.

From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month

D.

From Tableau Server. select Schedules and change the priority of the existing schedule

Full Access
Question # 9

A Data Analyst has the following chart.

The analyst needs to enable the drilldown from Category to Subcategory as shown in the following chart.

What should the analyst create?

A.

A bin for Category and a bin for Subcategory

B.

A hierarchy of Category and Subcategory

C.

A combined set for Category and Subcategory

D.

A group of Category and Subcategory

Full Access
Question # 10

A Data Analyst at a coffee company has the following visualization already built.

The analyst wants to make this more visually appealing by coloring the bars based on whether they are above or below the Average Sales within each Product Type.

Which calculation should the analyst use to calculate the Average Sales for each Product Type?

A.

( FIXED [Product] : AVG( (FIXED [Product Type] : AVG( [Sales] ) ) )

B.

{ EXCLUDE [Product] : SUM( [Sales] ) }

C.

{ FIXED [Product Type] : AVG( [Sales] ) }

D.

: FIXED ([Product Type]) : AVG( [ FIXED [Product] : SUM( [Sales] ) ] )

Full Access
Question # 11

You have a database that includes field named sales, City and Region.

You have the following chart that shows the number of sales made in different cities.

You want to dynamically show the corresponding region when users hover their mouse over any of the bars.

What should you do?

A.

Right-click a in the chat, select Annotate and then select Mark.

B.

Right-click a bar in the chart select Mark Label and then select Always show.

C.

Edit the aliases for City.

D.

Drag Region to Tooltip on the Marks card

Full Access
Question # 12

You want to add a comment to March 2020 as shown in the following visualization.

You have the following sets in a Tableau workbook

• Top N Customers

• Customers of 2020

• Top N Products

• Sellers of 2020

Which two sets can you combine? Choose two

A.

Sellers of 2020

B.

Customers of 2020

C.

Top N Products

D.

Top N Customers

Full Access
Question # 13

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)

Full Access
Question # 14

In a dataset, a Data Analyst has a string field named Name that contains unnecessary semicolons.

Which function should the analyst use to remove the semicolons from the Name field?

A.

CONTAINS

B.

SPLIT

C.

FIND

D.

REPLACE

Full Access
Question # 15

You are creating an annual report in Microsoft Word.

In Tableau Desktop, you build a chart in a worksheet.

You want to create an image of the chart that you can add to the annual report.

What are two ways to create the image? Choose two.

A.

From the Worksheet menu, use the Export option.

B.

From the Worksheet menu, use the Copy option.

C.

From the File menu, use the Export As Version option.

D.

From the Dashboard menu, use the Export Image option.

E.

From the Dashboard menu, use the Copy Image option.

Full Access
Question # 16

You have the following dataset:

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

A.

Pronunciation

B.

Spelling

C.

Manual Selection

D.

Common Characters

Full Access
Question # 17

A Data Analyst needs to analyze the financial performance of the sales team. In order to make the dashboards easier to understand, the analyst needs to format the financial values to show the dollar symbol ($) in front of the value.

How should the analyst enable this formatting across the workbook?

A.

Right-click on the measure in the data pane, then click on Create and Calculated Field to convert to a string and add the $ symbol.

B.

Right-click on the measure in the data pane, then click on Default Properties and Number Format.

C.

Click on the Format tab and select Workbook Theme.

D.

Click on the Analysis tab and select Forecast.

Full Access
Question # 18

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

Full Access
Question # 19

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.

Full Access
Question # 20

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.

Full Access
Question # 21

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.

Full Access
Question # 22

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.

Full Access
Question # 23

Open the link to Book1 found on the desktop. Open Disciplines worksheet.

Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.

Full Access
Question # 24

Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.

Create a filed map to show the distribution of total Sales by State across the United States.

Full Access
Question # 25

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.

Full Access
Question # 26

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

Full Access
Question # 27

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.

Full Access
Question # 28

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.

Full Access
Question # 29

A colleague provides you with access to a folder that contains the following files:

• Sates.csv

• Bookl.twb

• Sates.hyper

• Export.mdb

Which He contains an extract?

A.

Export mdb

B.

Book1.twb

C.

Sales.hyper

D.

Sales.csv

Full Access
Question # 30

You have a line chart on a worksheet.

You want to add a comment to March 2020 as shown in the following visualization.

What should you do?

A.

Drag the growth rate to Text on the Marks card

B.

Enable captions

C.

Annotate March 2020

D.

Add a tooltip

Full Access
Question # 31

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?

A.

August

B.

October

C.

December

D.

November

Full Access
Question # 32

You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

A.

South

B.

Cast

C.

Central

D.

West

Full Access
Question # 33

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

Full Access
Question # 34

You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.

You need to configure be shapes to be much larger than the line.

What should you do?

A.

Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently

B.

Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository

C.

For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset

D.

Change Population to a discrete dimension

Full Access
Question # 35

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.

Extract Refreshes

C.

Connected Workbooks

D.

Connections

Full Access
Question # 36

You have the following dashboard that contains two visualizations.

You want to show only one visualization at time. Users must be able to switch between visualizations.

What should you me?

A.

A parameter and a calculated filed

B.

Worksheet actions

C.

Show/hide buttons

D.

Dashboard actions

Full Access