Salesforce Certified Tableau Data Analyst Exam Questions

Question 6 of 64

A Data Analyst has a data source with row data for service calls and their activity log.
Exam Certified Tableau Data Analyst: Question 6 - Image 1

Which calculation allows the analyst to count the calls that have never had a technician assigned to them?

COUNT ( IF {INCLUDE [Activity Name]: NOT ‘Assign Technician’ } THEN [Call ID] END )

SUM( {FIXED [Call ID]: IF MAX( [Activity Name]= ‘Assign Technician’) THEN 0 ELSE 1 END } )

COUNT( {FIXED [Call ID]: IF [Activity Name]<> ‘Assign Technician’ THEN 1 ELSE 0 END } )

SUM( {INCLUDE [Activity Name]: COUNT(IF [Activity Name] <> ‘Assign Technician’ THEN 1 END) } )

Correct Answer: B

Question 7 of 64

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.
Exam Certified Tableau Data Analyst: Question 7 - Image 1

Exam Certified Tableau Data Analyst: Question 7 - Image 1

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?

Top

Special

Condition

Range

Correct Answer: C

Question 8 of 64

What happens within Tableau Prep Builder when a Data Analyst selects Publish as Data Source for a flow output step?

The flow output is saved to the database

The flow output is saved locally as a Tableau Data Source

The flow output is published as a data source on the server

The flow is published to the Tableau Server environment.

Correct Answer: C

Question 9 of 64

A Data Analyst wants to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should the analyst do from Tableau Desktop?

Select New Data Source from the Data menu.

Select New from the File menu.

Select Replace Data Source from the Data menu.

Select Import Workbook from the File menu.

Correct Answer: A

Question 10 of 64

A Data Analyst has the following map that shows profits per state in the United States.
Exam Certified Tableau Data Analyst: Question 10 - Image 1

How are the colors configured for the map?

A diverging color palette that has five stepped colors

A single color gradient

A sequential color gradient

A diverging color palette that has six stepped colors

Correct Answer: D