Databricks Certified Data Engineer Associate Exam Databricks-Certified-Data-Engineer-Associate Question # 20 Topic 3 Discussion

Databricks Discussions Browse All Questions Go to Exam Detail Get Premium Access

Previous

Next

Databricks Certified Data Engineer Associate Exam Databricks-Certified-Data-Engineer-Associate Question # 20 Topic 3 Discussion

Databricks-Certified-Data-Engineer-Associate Exam Topic 3 Question 20 Discussion:

Question #: 20

Topic #: 3

A data engineering team has two tables. The first table march_transactions is a collection of all retail transactions in the month of March. The second table april_transactions is a collection of all retail transactions in the month of April. There are no duplicate records between the tables.
Which of the following commands should be run to create a new table all_transactions that contains all records from march_transactions and april_transactions without duplicate records?

A.

CREATE TABLE all_transactions AS

SELECT * FROM march_transactions

INNER JOIN SELECT * FROM april_transactions;

B.

CREATE TABLE all_transactions AS

SELECT * FROM march_transactions

UNION SELECT * FROM april_transactions;

C.

CREATE TABLE all_transactions AS

SELECT * FROM march_transactions

OUTER JOIN SELECT * FROM april_transactions;

D.

CREATE TABLE all_transactions AS

SELECT * FROM march_transactions

INTERSECT SELECT * from april_transactions;

E.

CREATE TABLE all_transactions AS

SELECT * FROM march_transactions

MERGE SELECT * FROM april_transactions;

Get Premium Databricks-Certified-Data-Engineer-Associate Questions

Actual exam question for Databricks Databricks-Certified-Data-Engineer-Associate exam by Lyric49394 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:

Chosen Answer: A B C D E
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Previous

Next