Salesforce Analytics-DA-201 Exam Questions Instant Access

Question 1

Below are some of the values in the Order_ID field:

Which calculation should a Data Analyst use to return the two-letter combinations starting with the letter "P" for each of these values?

ASPLIT([Order_ID], '_', -2)

BFINDNTH([Order_ID], 'P*', 1)

CMID([Order_ID], FIND([Order_ID], 'P') + 1, 2)

DLEFT(SPLIT([Order_ID], '_', 2), 2)

Answer : C

Question 2

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

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?

A12

B50

C15

DAn error

Answer : A

Question 3

A Data Analyst has a data source that contains data for every city in the United States. The following is a sample of the data.

The analyst needs to use the City dimension to create a dynamic filter that shows the cities that have a population greater than 1 million.

Which type of filter should the analyst use?

ARange

BSpecial

CCondition

DTop

Answer : C

Question 4

Which option must a Data Analyst enable to build the following table to add quarterly totals?

AAdd All Subtotals

BShow Column Grand Totals

CShow Row Grand Totals

DAdd Pane Totals

Answer : A

Question 5

In a dataset, you have a string field named Name that contains unnecessary semicolons.

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

ATRIM

BCONTAINS

CREPLACE

DSPLIT

Answer : C

The REPLACE function is used to replace all occurrences of a substring within a string with another substring. In this case, it can be used to remove the semicolons from the Name field by replacing them with an empty string. For example, REPLACE (''John;Doe'', '';'', '''') = ''JohnDoe''.Reference:The information is based on the following sources:

String Functions - Tableau

Remove special characters and add a semi colon in a word - Tableau

Question 6

A Data Analyst creates a parameter named Choose Region that contains values from a field named Region.

The analyst wants users to be able to use the Choose Region parameter to interact with a chart by toggling between different regions.

What should the analyst do next?

AAdd Region to the Filters card.

BAdd the Choose Region parameter to the Pages card.

CSet the Choose Region parameter to Single Value (list).

DAdd the [Region] = [Choose Region] formula to the Filters card.

Answer : D

Question 7

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

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

ACOUNTD ( [NAME] )

BCOUNT ( [Award] )

CWINDOW_COUNT ( [Award] )

DCOUNTD ( [Award] )

Answer : D

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