Tableau Connecting & Preparing Data 2

Question 1

Which Tableau join type returns only the rows that have matching values in both tables?

Accepted Answer

Inner join

Answer

Left join

Answer

Right join

Answer

Full outer join

Question 2

What does a left join return when there is no matching row in the right table?

Accepted Answer

The unmatched left rows with null values for right columns

Answer

Nothing for that row

Answer

An error message

Answer

Only the right table rows

Question 3

In Tableau, what is the main difference between a join and a relationship (noodle)?

Accepted Answer

Relationships are flexible and defer join logic until analysis

Answer

Joins are only for Excel files

Answer

Relationships merge tables into one fixed table

Answer

There is no functional difference

Question 4

Which connection mode in Tableau queries the source database directly each time the view is refreshed?

Accepted Answer

Live connection

Answer

Extract connection

Answer

Snapshot mode

Answer

Offline mode

Question 5

What file format does a Tableau data extract use?

Accepted Answer

.hyper

Answer

.twb

Answer

.csv

Answer

.tde only

Question 6

A union in Tableau combines tables by doing what?

Accepted Answer

Stacking rows from tables with similar structures

Answer

Adding columns side by side

Answer

Multiplying rows together

Answer

Removing duplicate columns

Question 7

Which feature lets you automatically union files whose names match a pattern in a folder?

Accepted Answer

Wildcard union

Answer

Cross-database join

Answer

Data blending

Answer

Pivot