Valid TDA-C01 Dumps shared by ExamDiscuss.com for Helping Passing TDA-C01 Exam! ExamDiscuss.com now offer the newest TDA-C01 exam dumps, the ExamDiscuss.com TDA-C01 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com TDA-C01 dumps with Test Engine here:
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?
Correct Answer: A
To combine the tables by using Tableau Prep and include only values from Table1 that do not match any values in Table2, you should use a left only join. A left only join is a type of join that returns only the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2). The field values from Table2 will appear as null values in the combined table. A left only join is also known as an anti-join or an exclusion join. Reference: Tableau Certified Data Analyst Exam Prep Guide, page 9, section "Preparing Data" Tableau Help: Join Your Data Tableau Help: Left Only Join
