Explanation:
The correct SQL command to append a new record to an existing table is INSERT INTO my_table VALUES (‘c01‘, 9, 6.2). This command specifies the table name (my_table) and the values for the new record, which must align with the table's schema. This method is straightforward and efficiently adds the specified data as a new row to the table.
Ultimate access to all questions.
A data engineer is tasked with appending a new record to an existing Delta table named my_table. The record to be added has the following details: id STRING = ‘c01‘, rank INTEGER = 9, and rating FLOAT = 6.2. Which SQL command should the engineer use to successfully add this new record to my_table?
A
my_table UNION VALUES (‘c01‘, 9, 6.2)
B
UPDATE my_table VALUES (‘c01‘, 9, 6.2)
C
INSERT INTO my_table VALUES (‘c01‘, 9, 6.2)
D
UPDATE VALUES (‘c01‘, 9, 6.2) my_table
E
INSERT VALUES (‘c01‘, 9, 6.2) INTO my_table
No comments yet.