Winter Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

TDA-C01 Tableau Certified Data Analyst Exam Questions and Answers

Questions 4

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

TDA-C01 Question 4

Options:

Buy Now
Questions 5

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?

TDA-C01 Question 5

Options:

Buy Now
Questions 6

You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.

The following is a sample of the data.

TDA-C01 Question 6

You want to improve the performance of the views by including only animals of a particular type.

To which filter should you add the Type field on the worksheet?

Options:

A.

Dimension filler

B.

Table calculation filter

C.

Context filter

D.

Measure filter

Buy Now
Questions 7

You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.

You create several filters.

From the Data Source page you plan to add data source fillers

When type of filter will appear in the Edit Data Source Filters dialog box?

Options:

A.

A table calculation filter used on Sheet

B.

A top N condition filer on a dimension in Sheet 1 and Sheet2

C.

A context filler on a dimension m Sheet3

D.

A dimension filter on all the sheets

Buy Now
Questions 8

You have the following two datasets:

• A Microsoft Excel worksheet that has two columns named Employee Name and Department

• A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.

You want to use Tableau Prep to join the two datasets.

Which three actions should you perform in order? (Place the three correct options in order.)

Options:

Buy Now
Questions 9

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)

TDA-C01 Question 9

Options:

Buy Now
Questions 10

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 11

You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?

Options:

A.

General filter

B.

Wildcard filter

C.

Top filter

D.

Condition filter

Buy Now
Questions 12

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

Options:

Buy Now
Questions 13

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.

Options:

Buy Now
Questions 14

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 15

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.

Options:

Buy Now
Questions 16

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 17

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 18

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.

Options:

Buy Now
Questions 19

You have the Mowing dashboard.

TDA-C01 Question 19

Which two elements are floating? Choose two.

Options:

A.

The state filter

B.

The color legend

C.

The map

D.

The Rate of Obesity chart

E.

The little

Buy Now
Questions 20

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?

Options:

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

Buy Now
Questions 21

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.

TDA-C01 Question 21

Options:

Buy Now
Questions 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%.

TDA-C01 Question 22

Options:

Buy Now
Questions 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.

TDA-C01 Question 23

Options:

Buy Now
Questions 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.

Options:

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

PDF + Testing Engine

$66  $164.99

Testing Engine

$50  $124.99
buy now TDA-C01 testing engine

PDF (Q&A)

$42  $104.99
buy now TDA-C01 pdf