Free Databricks Certified Data Analyst Associate Actual Exam Questions - Question 7 Discussion

C/B? This looks like an attempt to insert all rows from one table into another, but the use of TABLE after INSERT INTO isn’t standard SQL. Normally, you’d do INSERT INTO suppliers SELECT * FROM new_suppliers. So I’m thinking the command won’t run as is, which points to B. But if it did work, it would just add all rows including duplicates, so that matches C’s description. Still, syntax is the bigger problem here.

It’s B. The syntax isn’t right for any standard SQL I know—INSERT INTO usually needs VALUES or a SELECT statement, not a TABLE keyword like this. So it seems like this command would just throw an error rather than doing anything to the tables.

Probably B. The command doesn’t follow typical SQL INSERT syntax like INSERT INTO table SELECT, so it looks like it would error out rather than insert data.

Guessing B, the syntax looks off compared to usual INSERT INTO SELECT commands.

Good point on the syntax being off; I also think it won’t run, so B.

B. This syntax doesn't match standard SQL commands I'm familiar with, so it should throw an error rather than execute successfully.

B, the syntax isn’t standard SQL, so it should fail.

It’s B, the syntax looks off and should cause an error.

Looks like the command is trying to insert data from new_suppliers into suppliers. I think C fits best because it adds the new data without removing duplicates. The command syntax seems okay for that. Anyone else?