Databricks Certified Data Analyst - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data analyst executes the following command:
INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;
INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;
What is the result of this command?_
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._