Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

  1. Home
  2. Discussions
  3. Databricks
  4. Databricks Certification
  5. Databricks-Certified-Data-Engineer-Associate Discussions
  6. Databricks-Certified-Data-Engineer-Associate Exam Topic 6 Question 55 Discussion

Databricks Certified Data Engineer Associate Exam Databricks-Certified-Data-Engineer-Associate Question # 55 Topic 6 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 # 55 Topic 6 Discussion

Databricks-Certified-Data-Engineer-Associate Exam Topic 6 Question 55 Discussion:
Question #: 55
Topic #: 6

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 ASSELECT * FROM march_transactionsINNER JOIN SELECT * FROM april_transactions;

B.

CREATE TABLE all_transactions ASSELECT * FROM march_transactionsUNION SELECT * FROM april_transactions;

C.

CREATE TABLE all_transactions ASSELECT * FROM march_transactionsOUTER JOIN SELECT * FROM april_transactions;

D.

CREATE TABLE all_transactions ASSELECT * FROM march_transactionsINTERSECT SELECT * from april_transactions;

E.

CREATE TABLE all_transactions ASSELECT * FROM march_transactionsMERGE SELECT * FROM april_transactions;

Get Premium Databricks-Certified-Data-Engineer-Associate Questions
Actual exam question for Databricks Databricks-Certified-Data-Engineer-Associate exam by Echo4348 at Jul 21, 2026, 7:55:47 AM

Contribute your Thoughts:


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

Submit
 Previous
Next