March Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

TDA-C01 Exam Dumps - Tableau Certified Data Analyst Exam

Question # 4

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 # 5

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)

Full Access
Question # 6

You have the Mowing dashboard.

Which two elements are floating? Choose two.

A.

The state filter

B.

The color legend

C.

The map

D.

The Rate of Obesity chart

E.

The little

Full Access
Question # 7

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
Question # 8

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 # 9

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 # 10

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 # 11

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 # 12

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 # 13

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 # 14

You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

A.

Pronunciation

B.

Spelling

C.

Common Characters

D.

Manual Selection

Full Access
Question # 15

You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.

DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.

You want to combine the tables to meet the following requirements:

. Each record in Employeelnfo must be retained in the combined table.

. The records must contain the Department Name, Size, and VP fields.

· Every record must have a full name.

Which type of join should you use?

A.

Inner

B.

Left

C.

Full outer

D.

Union

Full Access
Question # 16

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?

Full Access
Question # 17

You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.

What should you do?

A.

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

B.

Right-click Sheet2 and select Add to Dashboard.

C.

From the context menu of Sheet3, select Deselect.

D.

Drag Sheet2 to the dashboard.

E.

From the context menu of Sheet3, select Remove Dashboard Item.

Full Access
Question # 18

You have a table that contains the following data.

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

Full Access
Question # 19

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.

A.

ZN ([Profits])

B.

ISNULL ([Profits])

C.

IFNULL [(profits] ,0)

D.

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

Full Access
Question # 20

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 # 21

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 # 22

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 # 23

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 # 24

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 # 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 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 # 27

You have the following visualization.

Full Access
Question # 28

You are developing a data source in Tableau Prep.

You have two tables named Orders and Employees.

The Orders table was created in 2019 and contains the following columns.

The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns

You want to prepare the data so that you can analyze sales trends over time for every sales team.

Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area. Use Answer Area arrows to re-order the options.)

Full Access
Question # 29

You have the following Map.

You need the map to appear as shown in the following visualization.

What should you do?

A.

Drag Location to Size on the Marks card.

B.

Change the opacity to 75%.

C.

Drag Population to Size on the Marks card.

D.

Change the mark type to Density.

E.

Change the mark type to Map.

Full Access
Question # 30

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

Full Access