TDA-C01 practice question 9 of 25
You have a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table. You want 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 you use?
Full set: 117 questionsA "Left only" join, also known as a left anti-join, is designed to return only the rows from the left (primary) table that do not have a matching value in the right (secondary) table based on the join key. This operation precisely fulfills the requirement to isolate values from Table1 that have no match in Table2. In the resulting data set, the fields originating from Table2 will be null, as no corresponding records were found. Tableau Prep's visual join interface allows you to select this specific subset of unmatched records from the left input.
B. Union: A union appends rows from tables with matching column structures; it does not compare rows based on a key to find non-matches.
C. Inner: An inner join returns only the rows that have matching keys in both tables, which is the opposite of the requirement.
D. Left: A standard left join returns all rows from the left table, including both matched and unmatched records, not just the non-matching ones.
E. Full outer: A full outer join returns all rows from both tables, whether they match or not, which is more inclusive than required.
1. Tableau Help. "Join your data". Tableau Software, LLC. In the section "Review the join results," the documentation explains that the join profile pane shows a summary of the results. This includes the number of included and excluded values. The diagram illustrates how a join is composed of the matched records (inner) and the unmatched records from the left and right inputs. Selecting only the unmatched records from the left input achieves a "Left only" result.
2. Tableau Help. "About the Tableau Prep Builder interface". Tableau Software, LLC. The section on the "Profile pane" for a Join step details how users can see a summary of the join results. It explicitly shows counts for "Joined" and "Unmatched" records for each table, allowing the user to interact with and isolate these specific sets of data, such as the "Left only" (unmatched) records.
Keep practicing
Take the free TDA-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
