ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 100 - TDA-C01 discussion

Report
Export

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?

A.
Left only
Answers
A.
Left only
B.
Union
Answers
B.
Union
C.
Inner
Answers
C.
Inner
D.
Left
Answers
D.
Left
E.
Full outer
Answers
E.
Full outer
Suggested answer: A

Explanation:

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

asked 23/09/2024
JEAN-MARIE HERMANT
48 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first