
Ultimate access to all questions.
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_