You have the following two tables.
Table A is the primary table.
Which type of join is established when a blend is created by using the join key of Category?
TDA-C01 Exam QuestionsBrowse all questions from this exam
TDA-C01 Exam - Question 50
Show AnswerHide Answer
Correct Answer: B
When a blend is created using the join key of Category, a left join is established. In a left join, all records from the primary table (Table A in this case) are included in the result, along with the matching records from the secondary table (Table B). If there is no match, the result from the secondary table will be NULL. This allows all the data from Table A to be retained, while corresponding data from Table B is included wherever matches are found.
Discussion
3 commentsasiat2301
May 24, 2024Correct anwer
106c207Option: B
May 24, 2024Blend works like a left join
MonBoujOption: B
May 29, 2024B. Left join Data blending simulates a traditional left join.