🔥 3-day streak
Databricks Certified Data Engineer Associate70 / 150
Question 70 of 150

A data engineer is reconciling two daily snapshots: a 'crm_customers' table and a 'billing_customers' table, both keyed on customer_id. The goal is to produce a single result that includes every customer_id present in either table, showing NULLs for columns from whichever side is missing so that mismatches can be flagged. Which join type should be used?

Reviewed for accuracy · Report an issueNext question