Tableau Desktop Specialist — Question 76

A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.

The analyst wants to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do not match any values in Table2. The field values from Table2 must appear as null values.

Which type of join should the analyst use?

Answer options

• A. Left only
• B. Left
• C. Union
• D. Inner
• E. Full outer

Correct answer: A

Explanation

The correct answer is 'Left only' because it allows the inclusion of all records from Table1 while returning nulls for non-matching records in Table2. The other options do not meet the requirement of excluding matching records from Table2, with 'Left' including all from Table1 but not nullifying Table2 values, 'Union' combining rows instead of filtering, 'Inner' only including matches, and 'Full outer' including all records from both tables.