🔥 3-day streak
Databricks Certified Data Engineer Associate73 / 150
Question 73 of 150

A data engineer is building a Silver table that combines an 'orders' DataFrame with a 'customers' DataFrame on customer_id. The business requirement is that every order must appear in the result, even if the order references a customer_id that does not exist in the customers table (so those customer columns should be null). Which join type should the engineer use?

Reviewed for accuracy · Report an issueNext question