Question 290
A hotfix changed production schema directly and the next DACPAC deployment would undo an undocumented object. Which implementation step most directly addresses this requirement?
Explanation
Correct Answer
Schema drift detection compares live target to the source-controlled expected model. Resolve the drift in source control or explicitly approved plan before deployment. Preflight detects unauthorized target changes and blocks risky deployment.
Incorrect Answers
Drift checks must compare the actual target and the expected model before allowing destructive deployment.
Drift may reflect an approved hotfix; review the ticket, dependents and safe source-control reconciliation first.
Reconcile valid hotfix DDL into source or an explicit reviewed exception; future deployments otherwise risk reversal.