You are tasked with combining data from two tables: `orders` (2021 data) and `orders_archive` (2020 data). There might be duplicate rows between them. Which SQL statement will merge the data from both tables while removing duplicates?_

Real Exam

SELECT * FROM orders INTERSECT SELECT * FROM orders_archive_

8.9%

SELECT * FROM orders UNION SELECT * FROM orders_archive_

63.9%

SELECT distinct * FROM orders JOIN orders_archive on order.id = orders_archive.id*

15.0%

SELECT * FROM orders_archive MINUS SELECT * FROM orders_

5.7%

SELECT * FROM orders UNION ALL SELECT * FROM orders_archive_

6.4%

Databricks Certified Data Engineer - Associate