exam questions

Exam TDA-C01 All Questions

View all questions & answers for the TDA-C01 exam

Exam TDA-C01 topic 1 question 180 discussion

Actual exam question from Tableau's TDA-C01
Question #: 180
Topic #: 1
[All TDA-C01 Questions]

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?

  • A. Left only
  • B. Left
  • C. Union
  • D. Inner
  • E. Full outer
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
janasuresh
3 weeks, 1 day ago
Selected Answer: A
left Only : For each row, includes only values from the left table that don't match any values from the right table. Field values from the right table show as null values in the join results.
upvoted 2 times
...
Lakshmi2023
1 month ago
Selected Answer: B
The join type should be "Left". There is nothing called "Left only" join.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago