Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

Databricks Certified Data Engineer Associate Exam Databricks-Certified-Data-Engineer-Associate Question # 44 Topic 5 Discussion

Databricks Certified Data Engineer Associate Exam Databricks-Certified-Data-Engineer-Associate Question # 44 Topic 5 Discussion

Databricks-Certified-Data-Engineer-Associate Exam Topic 5 Question 44 Discussion:
Question #: 44
Topic #: 5

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.

INSERT INTO my_table VALUES ( ' a1 ' , 6, 9.4)


B.

my_table UNION VALUES ( ' a1 ' , 6, 9.4)


C.

INSERT VALUES ( ' a1 ' , 6, 9.4) INTO my_table


D.

UPDATE my_table VALUES ( ' a1 ' , 6, 9.4)


E.

UPDATE VALUES ( ' a1 ' , 6, 9.4) my_table


Get Premium Databricks-Certified-Data-Engineer-Associate Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.