Answer-first summary for fast verification
Answer: INSERT INTO my_table VALUES ('a1', 6, 9.4)
The correct SQL command to append a new record to an existing Delta table is 'INSERT INTO my_table VALUES ('a1', 6, 9.4)'. Options B, C, and D are incorrect because they either use the wrong syntax or represent operations that are not meant for inserting data. Option B's syntax is incorrect for standard SQL. Option C and D use the 'UPDATE' keyword, which is used for modifying existing records rather than appending new ones.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
In the context of managing data in Databricks, a data engineer has received a new record with the following attributes: id as a STRING with a value of 'a1', rank as an INTEGER with a value of 6, and rating as a FLOAT with a value of 9.4. What SQL commands can be used to append this new record to an existing Delta table named my_table?
A
INSERT INTO my_table VALUES ('a1', 6, 9.4)
B
INSERT VALUES ('a1', 6, 9.4) INTO my_table
C
UPDATE my_table VALUES ('a1', 6, 9.4)
D
UPDATE VALUES ('a1', 6, 9.4) my_table