Exam Databricks-Certified-Professional-Data-Engineer Topic 5 Question 24 Discussion

Actual exam question for Databricks's Databricks-Certified-Professional-Data-Engineer exam
Question #: 24
Topic #: 5

You are working on a table called orders which contains data for 2021 and you have the second table called orders_archive which contains data for 2020, you need to combine the data from two tables and there could be a possibility of the same rows between both the tables, you are looking to combine the results from both the tables and eliminate the duplicate rows, which of the following SQL statements helps you accomplish this?

A. SELECT * FROM orders UNION SELECT * FROM orders_archive
(Correct) B. SELECT * FROM orders INTERSECT SELECT * FROM orders_archive C. SELECT * FROM orders UNION ALL SELECT * FROM orders_archive D. SELECT * FROM orders_archive MINUS SELECT * FROM orders E. SELECT distinct * FROM orders JOIN orders_archive on order.id = or-ders_archive.id

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business