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

Salesforce Analytics-DA-201 - Salesforce Certified Tableau Data Analyst

Page: 6 / 7
Total 212 questions

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

You have a data source that contains 20 tables.

You want the tables to be organized within the Data pane based on the type of data contained within the tables.

What should you use?

A.

Folders

B.

Hierarchies

C.

Sets

D.

Groups

A Data Analyst is creating a new dashboard.

The analyst needs to add a button to the dashboard that allows users to export the dashboard as an image.

Which type of object should the analyst use?

A.

Navigation

B.

Image

C.

Download

D.

Extension

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

When using Tableau Desktop to connect to a published data source on Tableau Cloud or Tableau Server, which data sources will be displayed to the user?

A.

Only the data sources the user has created themselves previously

B.

Only certified data sources

C.

Only the data sources the user has the Connect permission to

D.

Only data sources in the user ' s home directory

You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.

What should you do?

A.

Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.

B.

Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.

C.

Select the top 10 bars, and then change the color by selecting Color on the Marks card.

D.

Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.

You have a data source that contains the following columns.

You want to sort customers based on the most expensive orders.

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

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

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

You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

A.

Image

B.

Sheet

C.

Web page

D.

Horizontal