Answer-first summary for fast verification
Answer: INSERT INTO my_table VALUES ('a1', 6, 9.4)
Option A is the correct SQL command to append the new record to the existing Delta table 'my_table'. The syntax 'INSERT INTO my_table VALUES ('a1', 6, 9.4)' correctly inserts the new values into the specified table. Options B, C, D, and E are not valid SQL syntax for inserting a new record.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a data engineer, you are tasked with adding a new record to an existing Delta table named my_table. The new record contains the following data: id (data type STRING) with a value of 'a1', rank (data type INTEGER) with a value of 6, and rating (data type FLOAT) with a value of 9.4. Which of the following SQL commands can be used to append this new record to the existing Delta table my_table?
A
INSERT INTO my_table VALUES ('a1', 6, 9.4)
B
my_table UNION VALUES ('a1', 6, 9.4)
C
INSERT VALUES ( 'a1' , 6, 9.4) INTO my_table
D
UPDATE my_table VALUES ('a1', 6, 9.4)
E
UPDATE VALUES ('a1', 6, 9.4) my_table
No comments yet.