Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
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?
Explanation:
Option A is the correct SQL command to append the new record to the existing Delta table 'my_table'. The syntax 'INSERT INTO my_table VALUES ('a1', 6, 9.4)' correctly inserts the new values into the specified table. Options B, C, D, and E are not valid SQL syntax for inserting a new record.