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

Output the final file

Answer

Connect to a new source

Answer

Schedule a refresh

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

Join two tables

Answer

Remove a data source

Answer

Create a chart

Question 3

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

Accepted Answer

Group and Replace (fuzzy match)

Answer

Pivot

Answer

Union

Answer

Output step

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

Only PDF reports

Answer

Only Excel charts

Answer

Only printed pages

Question 5

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

Accepted Answer

Field separator (delimiter)

Answer

Mark type

Answer

Color legend

Answer

Tooltip

Question 6

Why might you choose an extract over a live connection for a large slow database?

Accepted Answer

Extracts improve performance and enable offline use

Answer

Extracts always show real-time data

Answer

Live connections cannot be filtered

Answer

Extracts require no storage

Question 7

What does an incremental extract refresh do?

Accepted Answer

Add only new rows since the last refresh

Answer

Rebuild the entire extract every time

Answer

Delete the extract

Answer

Convert the extract to live