Databricks Certified Data Analyst Associate — Question 23

A data analyst runs the following command:
INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;
What is the result of running this command?

Answer options

• A. The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, and any duplicate data is deleted.
• B. The command fails because it is written incorrectly.
• C. The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, including any duplicate data.
• D. The suppliers table now contains the data from the new_suppliers table, and the new_suppliers table now contains the data from the suppliers table.
• E. The suppliers table now contains only the data from the new_suppliers table.

Correct answer: C

Explanation

The correct answer is C because the command is intended to append data from the new_suppliers table to the suppliers table without removing duplicates. Option A is incorrect as it suggests duplicates are deleted. Option B is wrong since the command's syntax is valid. Option D misrepresents the operation by indicating a swap of data, while E incorrectly states that the suppliers table only has the data from new_suppliers.