A transformation must return all rows from a orders DataFrame and attach matching customer attributes from a customers DataFrame, keeping orders even when no matching customer exists (those customer columns should be null). Which join type is correct?
Answer & explanation
Correct answer: D
WHY D: A left outer join keeps every row from the left (orders) and fills customer columns with null when there is no match — exactly the requirement. WHY NOT A: An inner join drops orders with no matching customer. WHY NOT B: A cross join produces the Cartesian product, exploding row counts. WHY NOT C: A right join keeps all rows from the right side (customers), not orders. WHY NOT E: A left semi join returns only left columns for matched rows and cannot attach customer attributes.