Winter Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netbudy65

TDA-C01 Tableau Certified Data Analyst Exam Questions and Answers

Questions 4

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.

Options:

Buy Now
Questions 5

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.

Options:

Buy Now
Questions 6

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.

Options:

Buy Now
Questions 7

You are the owner of an alert.

You receive an email notification that the alert was suspended

From where can you resume the suspended alert?

Options:

A.

The Data Source page of Tableau Desktop

B.

The Notification area of Tableau Prep

C.

The My Content area of Tableau web pages

D.

The Shared with Ma page

Buy Now
Questions 8

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 ?

Options:

Buy Now
Questions 9

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

Options:

A.

Sellers of 2020

B.

Customers of 2020

C.

Top N Products

D.

Top N Customers

Buy Now
Questions 10

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?

Options:

A.

A parameter and a calculated filed

B.

Worksheet actions

C.

Show/hide buttons

D.

Dashboard actions

Buy Now
Questions 11

You have the following data source in tableau Server.

You need to ensure that the data is updated every hour.

What should you select?

Options:

A.

New

B.

Extract Refreshes

C.

Connected Workbooks

D.

Connections

Buy Now
Questions 12

You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.

What should you do from Tableau Desktop?

Options:

A.

From the Data menu select New Data Source

B.

From the Data menu select Replace Data Source

C.

From the File menu select Import Workbook

D.

From the File menu select New

Buy Now
Questions 13

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?

Options:

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

Buy Now
Questions 14

You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.

What should you do?

Options:

A.

Right-click Sheet2 and select Add to Dashboard.

B.

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

C.

From the context menu of Sheet3. select Remove Dashboard item

D.

Drag Sheet2 to the dashboard.

E.

From the context menu of Sheet3. select Deselect

Buy Now
Questions 15

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?

Options:

A.

Drag the growth rate to Text on the Marks card

B.

Enable captions

C.

Annotate March 2020

D.

Add a tooltip

Buy Now
Questions 16

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

Options:

Buy Now
Questions 17

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?

Options:

A.

Export mdb

B.

Book1.twb

C.

Sales.hyper

D.

Sales.csv

Buy Now
Questions 18

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)

Options:

Buy Now
Questions 19

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?

Options:

Buy Now
Questions 20

You are subscribed to several views.

You need to unsubscribe from the views.

What should you use?

Options:

A.

The My Content area of Tableau web pages

B.

The Notifications area of Tableau Prep

C.

The Data Source page of Tableau Desktop

D.

The Shared with Me page

Buy Now
Questions 21

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.

Options:

A.

ZN ([Profits])

B.

ISNULL ([Profits])

C.

IFNULL [(profits] ,0)

D.

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

Buy Now
Questions 22

You have a dataset that contains sates data. 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

Options:

A.

SUM{[Sales]) IN (50000)

B.

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

C.

MAX< [Sales], 50000)

D.

[Sales] > 50000

Buy Now
Questions 23

You have a dataset that contains people and the awards they have won.

Which formula should you use to get the number of different types of awards that have been won?

Options:

A.

COVAR({Award})

B.

COUNTD({Award})

C.

COUNTD {(NAME])

D.

MAX {(Award})

E.

INDEX()

Buy Now
Questions 24

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?

Options:

A.

Wildcard

B.

Condition

C.

General

D.

Top

Buy Now
Questions 25

You have the following dataset

You need to create the following visualization.

Which quick table calculation should you drag to Text on the Marks card?

Options:

A.

Percent of Total

B.

Percent Difference

C.

Compound Growth Rate

D.

Percentile

Buy Now
Questions 26

You have a table that contains four columns named Order Date, Country, Sales, and Profit.

You need to add a column that shows the day of the week for each row. For example, orders placed on August 31, 2022, will show a day of

Wednesday.

How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Options:

Buy Now
Questions 27

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

Options:

Buy Now
Questions 28

You have the following chart that sorts states by the number of products each state has purchased.

Which formula should you use to include a number with the position of each state within each region?

Options:

A.

FIRST ()

B.

INDEX ()

C.

WINDOW_SUM(SUM ([Quantity]))

D.

LOOKUP (SUM ([Quantity]))

Buy Now
Questions 29

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?

Options:

A.

0

B.

2

C.

4

D.

3

Buy Now
Questions 30

You have a blank dashboard.

You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.

To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)

Options:

Buy Now
Questions 31

You have the Mowing two tables that contains data about the books in a library.

Both tables are incomplete so there are books missing from the tables.

You need to combine the tables. The solution must ensure that all the data is retained

Which type of join should you use?

Options:

A.

Full outer join

B.

Right join

C.

left join

D.

Inner join

Buy Now
Questions 32

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.

Options:

Buy Now
Questions 33

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.

Options:

Buy Now
Questions 34

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.

Options:

Buy Now
Exam Code: TDA-C01
Exam Name: Tableau Certified Data Analyst Exam
Last Update: Nov 21, 2024
Questions: 120

PDF + Testing Engine

$130

Testing Engine

$95

PDF (Q&A)

$80