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

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

How would the following update be handled?

A
The update is moved to separate ''restored'' column because it is missing a column expected in the target schema.
B
The new restored field is added to the target schema, and dynamically read as NULL for existing unmatched records.
C
The update throws an error because changes to existing columns in the target schema are not supported.
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