Answer-first summary for fast verification
Answer: full outer
The question requires returning all rows from both tables when merging them. A FULL OUTER JOIN is the only join type that preserves all rows from both tables, including matching rows and non-matching rows from either table. Inner join (A) returns only matching rows, left outer (C) returns all rows from the left table but only matching rows from the right, right outer (E) returns all rows from the right table but only matching rows from the left, and anti-joins (D and F) specifically exclude matching rows. The community discussion shows 100% consensus on B (full outer join) with multiple comments explaining that it's the only option that returns all rows from both tables, making it the correct choice.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have a Fabric tenant with a lakehouse. You intend to use a visual query to merge two tables. You need to guarantee that the query returns all rows from both tables.
Which join type should you use?
A
inner
B
full outer
C
left outer
D
right anti
E
right outer
F
left anti
No comments yet.