Halloween Sale Special Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with CertsForce

Viewing page 6 out of 7 pages
Viewing questions 51-60 out of questions
Questions # 51:

What is required to publish a data source to Tableau Server or Tableau Cloud from Tableau Desktop?

Options:

A.

A Creator site role


B.

Administrator permissions on the server


C.

A Tableau Public account


D.

View permissions on the project


Expert Solution
Questions # 52:

A Data Analyst has a dataset that contains people and the awards they have won.

Question # 52

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

Options:

A.

COUNTD ( [NAME] )


B.

COUNT ( [Award] )


C.

WINDOW_COUNT ( [Award] )


D.

COUNTD ( [Award] )


Expert Solution
Questions # 53:

In which step of Tableau Prep Builder can a Data Analyst create a single table based on a matching pattern of multiple file names?

Options:

A.

New Rows


B.

Join


C.

Union


D.

Input


Expert Solution
Questions # 54:

In a dataset, a Data Analyst has a string field named Name that contains unnecessary semicolons.

Which function should the analyst use to remove the semicolons from the Name field?

Options:

A.

CONTAINS


B.

SPLIT


C.

FIND


D.

REPLACE


Expert Solution
Questions # 55:

The following table displays the row-level data in a Tableau data source:

Question # 55

A Data Analyst creates this calculated field:

SUM(IF [Item] = ' A ' THEN [Sales] END) / COUNT([Order ID] )

What is the result of this aggregate calculation?

Options:

A.

12


B.

50


C.

15


D.

An error


Expert Solution
Questions # 56:

You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.

In which step can you transform rows of monthly data into rows of yearly data ' '

Question # 56


Expert Solution
Questions # 57:

You want to show the cumulative total of each year for every state.

Which quick table calculation should you use?

Options:

A.

VTD Growth


B.

Running Total


C.

Year Over Year Growth


D.

YTD Total


Expert Solution
Questions # 58:

You need to change the values of a dimension without creating a new field.

What should you do?

Options:

A.

Rename the fields


B.

Create aliases


C.

Create groups


D.

Transforms the fields


Expert Solution
Questions # 59:

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)

Question # 59


Expert Solution
Questions # 60:

You are creating a new dashboard.

You need to add a button to the dashboard that allows users to export the dashboard as an image.

Which type of object should you use?

Options:

A.

Image


B.

Ask Data


C.

Extension


D.

Download


E.

Navigation


Expert Solution
Viewing page 6 out of 7 pages
Viewing questions 51-60 out of questions