Question 470
A hotfix changed production schema directly and the next DACPAC deployment would undo an undocumented object. The team is considering this step: Resolve the drift in source control or explicitly approved plan before deployment. What evidence should they review before proceeding?
Explanation
Correct Answer
Extract target state, project baseline, deployment diff and hotfix ticket. Schema drift detection compares live target to the source-controlled expected model. 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.