Databricks Certified Data Engineer - Associate
Get started today
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?
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?
Exam-Like
A
INSERT INTO my_table VALUES ('a1', 6, 9.4)_
89.6%
B
my_table UNION VALUES ('a1', 6, 9.4)_
Comments
Loading comments...