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
?