Databricks Certified Data Engineer - Associate

Ultimate access to all questions.

A data engineer has been given a new record of data:

id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4

id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4

Which SQL commands can be used to append the new record to an existing Delta table my_table?

Real Exam

Community

KKeng

Last updated: January 13, 2026 at 09:15

INSERT INTO my_table VALUES ('a1', 6, 9.4)

INSERT VALUES ('a1', 6, 9.4) INTO my_table

UPDATE my_table VALUES ('a1', 6, 9.4)

UPDATE VALUES ('a1', 6, 9.4) my_table

Explanation:

Explanation

The correct answer is A because:

INSERT INTO is the standard SQL syntax for appending new records to a table.
The syntax INSERT INTO table_name VALUES (...) correctly specifies the table name first, followed by the VALUES clause containing the data to insert.
Option B has incorrect syntax - INSERT VALUES ... INTO is not valid SQL.
Option C uses UPDATE which is for modifying existing records, not appending new ones.
Option D also uses UPDATE with incorrect syntax.

Key Points:

INSERT INTO is used to add new rows to a table
UPDATE is used to modify existing rows
The correct syntax is INSERT INTO table_name VALUES (value1, value2, ...)
In Databricks with Delta tables, this command would append the new record to the existing Delta table structure.

Powered ByGPT-5.2

Loading comments...