Explanation:
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.
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