The following table consists of items found in user carts within an e-commerce website.

Databricks Databricks-Certified-Professional-Data-Engineer Question Answer

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?

The update is moved to separate ' ' restored ' ' column because it is missing a column expected in the target schema.

The new restored field is added to the target schema, and dynamically read as NULL for existing unmatched records.

The update throws an error because changes to existing columns in the target schema are not supported.

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 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"