Question 890
A SQL schema change is forward-only because historical customer data has been transformed. The team implemented this change: Plan a corrective migration with backups, dry run and explicit recovery criteria. Which result would best confirm the change worked?
Explanation
Correct Answer
A rehearsed incident restores service without violating data integrity. Some database migrations require tested rollforward correction rather than naive rollback. Point-in-time restore can lose post-backup accepted transactions.
Incorrect Answers
That observation could pass while the problem persists: Schema rollback cannot reconstruct discarded transformations; plan corrective rollforward and tested recovery.
This acceptance test measures the wrong outcome: Recovery needs explicit RPO/RTO, post-backup reconciliation and rehearsal; rollforward may be safer.
The suggested success signal is inadequate because Review application/data contracts and use staged evolution when mixed versions can run during rollout. The suggested measurement would appear successful even in a reproducible case where the original failure remains.