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

An inner join keeps only rows where the join keys match in both tables.

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

A left join keeps all left rows and fills right-table columns with null where no match exists.

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

Relationships keep tables separate and determine the appropriate join contextually at query time.

Question 4

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

Accepted Answer

Live connection

Answer

A live connection sends queries to the source database in real time.

Question 5

What file format does a Tableau data extract use?

Accepted Answer

.hyper

Answer

Modern Tableau extracts use the .hyper file format.

Tableau Practice Test