Your marketing team has requested your help to identify customers with identical information across two tables, `CUSTOMERS_2021` and `CUSTOMERS_2020`. Both tables share the same schema with 25 columns each. Which SQL operation would you use to find rows that match across all columns in both tables?

Real Exam

SELECT * FROM CUSTOMERS_2021 UNION SELECT * FROM CUSTOMERS_2020

11.8%

SELECT * FROM CUSTOMERS_2021 UNION ALL SELECT * FROM CUSTOMERS_2020

8.4%

SELECT * FROM CUSTOMERS_2021 C1 INNER JOIN CUSTOMERS_2020 C2 ON C1.CUSTOMER_ID = C2.CUSTOMER_ID*

19.2%

SELECT * FROM CUSTOMERS_2021 INTERSECT SELECT * FROM CUSTOMERS_2020

57.9%

SELECT * FROM CUSTOMERS_2021 EXCEPT SELECT * FROM CUSTOMERS_2020

2.7%

Databricks Certified Data Engineer - Associate