DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #23
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Question
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?
Options
- AINSERT INTO my_table VALUES ('a1', 6, 9.4)
- Bmy_table UNION VALUES ('a1', 6, 9.4)
- CINSERT VALUES ( 'a1' , 6, 9.4) INTO my_table
- DUPDATE my_table VALUES ('a1', 6, 9.4)
- EUPDATE VALUES ('a1', 6, 9.4) my_table
Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to see the answer
You've previewed enough free DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE questions. Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.