A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which SQL commands can be used to append the new record to an existing Delta table 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