A data engineer is tasked with identifying customers who have not placed any orders on an e-commerce platform. They have two Delta tables: `customers`, containing details of registered customers, and `orders`, containing details of orders placed. Which query correctly identifies these customers?

Real Exam

SELECT customer_id FROM customers INTERSECT SELECT order_customer_id FROM orders_

12.4%

SELECT customer_id FROM customers UNION SELECT order_customer_id FROM orders_

8.8%

SELECT customer_id FROM customers c INNER JOIN orders o ON c.customer_id = o.order_customer_id

14.5%

SELECT customer_id FROM customers UNION ALL SELECT order_customer_id FROM orders_

6.2%

SELECT customer_id FROM customers EXCEPT SELECT order_customer_id FROM orders_

58.0%

Databricks Certified Data Engineer - Associate