Tableau Connecting & Preparing Data 4

Question 1

In Tableau Prep, what is the purpose of a Clean step?

Accepted Answer

Apply filters, rename fields, and fix values in the data flow

Answer

A Clean step lets you filter, rename, group, split, and adjust field values within a flow.

Question 2

What does the Aggregate step in Tableau Prep do?

Accepted Answer

Group rows and roll up measures to a chosen level of detail

Answer

The Aggregate step groups data and summarizes measures to change granularity.

Question 3

Which Tableau Prep feature suggests grouping similar text values that may be misspellings?

Accepted Answer

Group and Replace (fuzzy match)

Answer

Group and Replace can use fuzzy matching to combine similar or misspelled values.

Question 4

What output options does a Tableau Prep flow's Output step support?

Accepted Answer

Extract files, published data sources, and database tables

Answer

An Output step can write to .hyper extracts, published data sources, or database tables.

Question 5

When connecting to a CSV in Tableau, which setting controls how text is divided into fields?

Accepted Answer

Field separator (delimiter)

Answer

The field separator defines the delimiter used to break each line into columns.

Tableau Practice Test