Discuss Databricks Databricks Certified Data Analyst Associate Exam Topic 2 Question 3

A data analyst runs the following command:

INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;

What is the result of running this command?

AThe 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.

BThe command fails because it is written incorrectly.

CThe 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.

DThe suppliers table now contains the data from the new suppliers table, and the new suppliers table now contains the data from the suppliers table.

EThe suppliers table now contains only the data from the new suppliers table.

Suggested Answer: B

The commandINSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliersis not a valid syntax for inserting data into a table in Databricks SQL.According to the documentation12, the correct syntax for inserting data into a table is either:

INSERT { OVERWRITE | INTO } [ TABLE ] table_name [ PARTITION clause ] [ ( column_name [, ...] ) | BY NAME ] query

INSERT INTO [ TABLE ] table_name REPLACE WHERE predicate query

The command in the question is missing theOVERWRITEorINTOkeyword, and thequerypart that specifies the source of the data to be inserted. TheTABLEkeyword is optional and can be omitted. ThePARTITIONclause and the column list are also optional and depend on the table schema and the data source. Therefore, the command in the question will fail with a syntax error.

INSERT | Databricks on AWS

INSERT - Azure Databricks - Databricks SQL | Microsoft Learn

Get Premium Databricks Certified Data Analyst Associate Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

17 comments · newest first

Antonette 10 months ago

I thought it would just replace the old data, not combine it!

Carlee 11 months ago

No way it deletes duplicates, that's not how SQL works.

Javier 11 months ago

Wait, does it really keep duplicates? That's odd.

Lindsay 11 months ago

Definitely goes with option C!

Wilbert 11 months ago

I think the command is actually incorrect.

Corrie 12 months ago

I thought the command would fail because of the syntax; it seems off to me, but I can't remember the exact rules for INSERT statements.

Rueben 12 months ago

I feel like option C makes the most sense since it says both sets of data will be combined, but I’m a bit confused about the duplicates part.

Noel 12 months ago

I remember a similar question where we discussed how INSERT commands work, but I can't recall if this syntax is correct.

Lavonne 1 year ago

I think the command is supposed to add data from the new suppliers table to the existing suppliers table, but I'm not sure if it handles duplicates.

Nakisha 1 year ago

I'm pretty confident I know the answer to this one. The INSERT INTO command will merge the data from the new_suppliers table into the suppliers table.

Lilli 1 year ago

Okay, let me break this down step-by-step. The key is understanding how the INSERT INTO statement works with a TABLE clause.

Haley 1 year ago

The wording of the question is a bit confusing. I'm not sure if the command is written correctly or what the expected result would be.

Chauncey 1 year ago

Hmm, this looks like a tricky SQL question. I'll need to think through the syntax and logic carefully.

Elli 1 year ago

I'm a bit unsure about this one. I'll need to review my SQL knowledge to determine the correct outcome of running this command.

Gabriele 1 year ago

I've got an idea - what if we use the ESB to cache the responses from the external systems and return a request ID to the Lightning UI? That way, the users can check for updates later without having to wait for the full response.

Amie 1 year ago

This is tricky! I feel like it might be about script parameters, but I'm not entirely confident.

Malika 1 year ago

Hmm, I'm a bit unsure about this one. The options seem pretty similar, so I'll need to really analyze each one to figure out the right answer.

Databricks Certified Data Analyst Associate Exam - Topic 2 Question 3 Discussion