Certified Tableau Data Analyst

Certified Tableau Data Analyst practice questions, page 2 of 3, with answer review and explanations.

Question 6

A Data Analyst has a data source with row data for service calls and their activity log. Which calculation allows the analyst to count the calls that have never had a technician assigned to them?

  1. COUNT ( IF {INCLUDE [Activity Name]: NOT ‘Assign Technician’ } THEN [Call ID] END )
  2. SUM( {FIXED [Call ID]: IF MAX( [Activity Name]= ‘Assign Technician’) THEN 0 ELSE 1 END } )
  3. COUNT( {FIXED [Call ID]: IF [Activity Name]<> ‘Assign Technician’ THEN 1 ELSE 0 END } )
  4. SUM( {INCLUDE [Activity Name]: COUNT(IF [Activity Name] <> ‘Assign Technician’ THEN 1 END) } )

Question 7

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?

  1. Top
  2. Special
  3. Condition
  4. Range

Question 8

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

  1. The flow output is saved to the database
  2. The flow output is saved locally as a Tableau Data Source
  3. The flow output is published as a data source on the server
  4. The flow is published to the Tableau Server environment.

Question 9

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?

  1. Select New Data Source from the Data menu.
  2. Select New from the File menu.
  3. Select Replace Data Source from the Data menu.
  4. Select Import Workbook from the File menu.

Question 10

A Data Analyst has the following map that shows profits per state in the United States. How are the colors configured for the map?

  1. A diverging color palette that has five stepped colors
  2. A single color gradient
  3. A sequential color gradient
  4. A diverging color palette that has six stepped colors