CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #105
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #105: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #105. The question stem and answer options stay visible for context.
Question
The following table consists of items found in user carts within an e-commerce website. The following MERGE statement is used to update this table using an updates view, with schema evaluation enabled on this table. How would the following update be handled?
Options
- AThe update is moved to separate ''restored'' column because it is missing a column expected in
- BThe new restored field is added to the target schema, and dynamically read as NULL for existing
- CThe update throws an error because changes to existing columns in the target schema are not
- DThe new nested field is added to the target schema, and files underlying existing records are
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.