Certified Data Analyst Associate Exam

Exam Certified Data Analyst Associate All QuestionsBrowse all questions from this exam

Question 21

A data analyst runs the following command:

INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;

What is the result of running this command?

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.

The command fails because it is written incorrectly.

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.

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.

The suppliers table now contains only the data from the new_suppliers table.

Correct Answer: C

The INSERT INTO command in SQL is used to add data to an existing table. When using the TABLE keyword, it indicates that data from another table (in this case, new_suppliers) is to be inserted into the target table (suppliers). Therefore, the suppliers table will contain both its previous data and the data from the new_suppliers table, including any duplicate data.

Discussion

Ayush24Option: C

As per Databrick documents, https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-dml-insert-into.html We can Insert using a TABLE clause.

libbsterOption: C

C is correct based on official Databricks documentation and example: INSERT INTO students TABLE visiting_students;

DevscopeOption: C

Try the following code, you will see that it runs without a problem: DROP TABLE IF EXISTS test; CREATE TABLE test (id INT, name VARCHAR(64)); INSERT INTO test VALUES (1, 'Person1'), (2, 'Person2'); -- SELECT * FROM test; DROP TABLE IF EXISTS test2; CREATE TABLE test2 (id INT, name VARCHAR(64)); INSERT INTO test2 VALUES (3, 'Person3'), (4, 'Person4'); -- SELECT * FROM test2; INSERT INTO test TABLE test2; SELECT * FROM test