Tableau Connecting & Preparing Data 3

Question 1

What does the Data Interpreter feature in Tableau help with?

Accepted Answer

Cleaning messy spreadsheets with titles, footnotes, and merged cells

Answer

Writing SQL queries

Answer

Building dashboards

Answer

Scheduling extract refreshes

Question 2

Which operation transforms columns into rows in Tableau's data source?

Accepted Answer

Pivot

Answer

Union

Answer

Join

Answer

Split

Question 3

The Split function on a field is used to do what?

Accepted Answer

Separate one column into multiple based on a delimiter

Answer

Merge two columns

Answer

Remove null values

Answer

Aggregate values

Question 4

What is a cross-database join in Tableau?

Accepted Answer

A join combining tables from different data sources

Answer

A join within a single Excel sheet

Answer

A union of CSV files

Answer

A blend of extracts

Question 5

When is data blending typically preferred over a join?

Accepted Answer

When combining data at different levels of granularity from separate sources

Answer

When all data is in one table

Answer

When you need a full outer join

Answer

When pivoting columns

Question 6

In data blending, what defines the link between the primary and secondary data sources?

Accepted Answer

A linking field common to both sources

Answer

A calculated field only

Answer

The first column alphabetically

Answer

The extract file name

Question 7

Which Tableau product is dedicated to advanced visual data cleaning and shaping workflows?

Accepted Answer

Tableau Prep Builder

Answer

Tableau Reader

Answer

Tableau Public

Answer

Tableau Mobile