A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which of the following SQL commands can be used to append the new record to an existing Delta table my_table?
A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which of the following SQL commands can be used to append the new record to an existing Delta table my_table?
The correct SQL command to append a new record to an existing Delta table is 'INSERT INTO my_table VALUES ('a1', 6, 9.4)'. This command uses proper syntax for inserting a row into a table, providing the correct values for each column specified in the question.
Ans A : check the correct syntax for insert into
A is correct
A is correct because syntax is correct
A is correct