Salesforce Analytics-DA-201 Exam Questions Instant Access

Question 1

A colleague provides a Data Analyst with access to a folder that contains the following files:

Sales.csv

Book1.twb

Sales.hyper

Export.mdb

Which file is a Tableau extract?

ASales.hyper

BSales.csv

CExport.mdb

DBook1.twb

Answer : A

Question 2

How are the colors configured for the map?

AA sequential color gradient

BA diverging color palette that has five stepped colors

CA diverging color palette that has six stepped colors

DA single color gradient

Answer : B

Question 3

Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?

ARUNNING_AVG

BINCLUDE

CAVG

DEXCLUDE

Answer : D

Question 4

A Data Analyst has the following dashboard.

Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.

The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.

What should the analyst do?

ASelect Remove Dashboard Item from the drop-down menu of Sales over time.

BSelect Ignore Actions from the drop-down menu of Sales over time.

CSelect Deselect from the drop-down menu of Sales over time.

DDeselect Use as Filter from drop-down menu of Profits by State

Answer : B

Question 5

You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

APronunciation

BSpelling

CCommon Characters

DManual Selection

Answer : B

Tableau Prep's Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.

Question 6

You have the following dataset.

You want to create a new calculated dimension field named Category that meets the following conditions:

. When Subject is Computer Science or Science, Category must be Sciences.

. When Subject is English or Social Studies, Category must be Humanities.

Which two logical functions achieve the goal? Choose two.

AIF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END

BIIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')

CIF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END

DCASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End

Answer : A, D

To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects.Reference:

Logical Functions - Tableau

Tableau Certified Data Analyst Study Guide

Question 7

You have a dataset that contains people and the awards they have won.

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

ACOVAR({Award})

BCOUNTD({Award})

CCOUNTD {(NAME])

DMAX {(Award})

EINDEX()

Answer : B

To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.

The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau. MAX({Award}) will return the maximum value in the Award field, which may not be a type of award. INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards. Reference: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#INDEX

The COUNTD function in Tableau calculates the number of distinct (unique) items in a field. When looking to get the number of different types of awards that have been won, the COUNTD([Award]) function will count each unique award name only once, regardless of how many times it appears in the dataset. This will return the total number of unique award types.

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