Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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 details are as follows: id STRING = ‘c01‘, rank INTEGER = 9, rating FLOAT = 6.2. Which SQL command should be used to add this new record to my_table?
A
UPDATE my_table VALUES (‘c01‘, 9, 6.2)_
B
INSERT INTO my_table VALUES (‘c01‘, 9, 6.2)_
C
UPDATE VALUES (‘c01‘, 9, 6.2) my_table_
D
my_table UNION VALUES (‘c01‘, 9, 6.2)_
E
INSERT VALUES (‘c01‘, 9, 6.2) INTO my_table_