Free DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine Demo

Q35 Single choice

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 evolution enabled on this table.

How would the following update be handled?

A
The update throws an error because changes to existing columns in the target schema are not supported.
B
The new nested Field is added to the target schema, and dynamically read as NULL for existing unmatched records.
C
The update is moved to a separate "rescued" column because it is missing a column expected in the target schema.
D
The new nested field is added to the target schema, and files underlying existing records are updated to include NULL values for the new field.

DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine demo