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

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

Page: 1 / 4
Total 174 questions

A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.

The analyst wants 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 the analyst use?

A.

Inner

B.

Left only

C.

Left

D.

Full outer

E.

Union

A Data Analyst has a dataset that contains the fallowing rows of sales data.

The analyst needs 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 this goal? (Choose two.)

A.

SUM([Sales]) IN (50000)

B.

[Sales] > 50000

C.

MAX([Sales], 50000)

D.

IF [Sales] > 50000 THEN TRUE ELSE FALSE END

You create the following story that contains two story point.

You want to change the story point format to show the current story point number out of the total number of story points.

Which Layout option should you use?

A.

Dots

B.

Arrows only

C.

Caption boxes

D.

Numbers

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.

What should a Data Analyst use to visualize the distribution and variability of measure values along an axis?

A.

Bullet Graph

B.

Box Plot

C.

Scatter Plot

D.

Histogram

You have a workbook that uses an extracted data source.

You publish the workbook to Tableau Server.

Which three actions can you perform from the Extract Refresh page in Tableau Server? Choose three.

A.

Run a refresh.

B.

Change the refresh from full to incremental.

C.

Change the priority of the refresh.

D.

Delete the refresh.

E.

Modify the frequency of the refresh.

A Data Analyst needs to develop a Sales Dashboard that users can access through a computer or by phone and tablet using the same URL link.

How should the analyst create dashboards that are formatted for specific devices?

A.

Use floating containers on the dashboard so that the content shifts responsively to adjust for each device.

B.

Add device layouts for the dashboard so that appropriate layouts are shown based on the device.

C.

Create a workbook for each device type and let the users know which one to open on which device.

D.

Set the dashboard size to Automatic and let Tableau adjust the layout automatically for each device size.

You have a sales dataset that contains the following fields.

You need to analyze the average revenue per product in different regions over time.

Which two fields should be measures? Choose two.

A.

Customer Region

B.

Order Date

C.

Product Name

D.

Quantity

E.

Revenue

You are subscribed to several views.

You need to unsubscribe from the views.

What should you use?

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

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.