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

Home > Tableau > Tableau Certified Data Analyst > TDA-C01

TDA-C01 Tableau Certified Data Analyst Exam Question and Answers

Question # 4

You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.

You want to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do NOT match any values in Table2. The field values from Table2 must appear as null values.

Which type of join should you use?

A.

Left only

B.

Union

C.

Inner

D.

Left

E.

Full outer

Full Access
Question # 5

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?

A.

Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.

B.

Add both sheets to the dashboard. Set Fit to Fix width.

C.

Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.

D.

Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.

Full Access
Question # 6

You have the following dataset.

You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?

A.

NAMEUSERNAME()

B.

ISFULLNAMETableu_USER_NAME))=USERNAME()

C.

NAME Tableau-USER-NAME)

D.

USERNAME()=(Tableau_USER_NAME)

Full Access
Question # 7

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

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

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

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?

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

Full Access
Question # 11

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

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

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

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

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

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)

Full Access
Question # 17

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

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

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

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 # 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 SalesVSProfit worksheet.

Add a distribution band on Profit to show the standard deviation from- 1 to 1.

Full Access
Question # 25

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 # 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. Open the Line worksheet.

Modify the chart to show only main and max values of both measures in each region.

Full Access
Question # 28

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

You have the following primary data source that contains a dimension named Dorm_Code.

You receive the following secondary data source that contains updated dorm codes.

You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.

What should you do?

A.

Bring in the secondary data source as a union.

B.

Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window

C.

Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New

D.

Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source

Full Access
Question # 30

You have a data source that contains the following columns.

You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.

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