CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #27
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #27: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.
Question
A junior data engineer on your team has implemented the following code block. The view new_events contains a batch of records with the same schema as the events Delta table. The event_id field serves as a unique key for this table. When this query is executed, what will happen with new records that have the same event_id as an existing record?
Options
- AThey are merged.
- BThey are ignored.
- CThey are updated.
- DThey are inserted.
- EThey are deleted.
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL 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.