Question 190
A generated deployment plan proposes dropping a populated customer column simply because it was renamed in source. Which recommendation best resolves this issue?
Explanation
Correct Answer
Automated schema comparison can interpret renames as destructive drop-and-create operations.
Incorrect Answers
Prepare a validated data backup or forward-fix recovery approach and test it before the change window: reverting a schema definition cannot recreate data already deleted or transformed irreversibly.
Stage the change with a backfill or safe default and validate constraints before enforcing NOT NULL: stage the change with a backfill or safe default and validate constraints before enforcing NOT NULL: existing data must satisfy new column constraints during deployment, not only future inserts.
Detect schema drift against the SQL Database Project and reconcile approved exceptions before publishing deployment: detect schema drift against the SQL Database Project and reconcile approved exceptions before publishing deployment: drift checks identify differences between the source model and the actual target database.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests