Question 116 of 307
Single answerThe 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?
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?
AThe update throws an error because changes to existing columns in the target schema are not supported.
✓BThe new nested Field is added to the target schema, and dynamically read as NULL for existing unmatched records.
CThe update is moved to a separate "rescued" column because it is missing a column expected in the target schema.
DThe new nested field is added to the target schema, and files underlying existing records are updated to include NULL values for the new field.
✓
Correct Answer: B
The new nested Field is added to the target schema, and dynamically read as NULL for existing unmatched records.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.