Question 590
A SQL schema change is forward-only because historical customer data has been transformed. Initial testing shows: A rehearsed incident restores service without violating data integrity. Which limitation should the team still consider?
Explanation
Correct Answer
Point-in-time restore can lose post-backup accepted transactions. Some database migrations require tested rollforward correction rather than naive rollback.
Incorrect Answers
That residual-risk statement assumes an invalid guarantee: Schema rollback cannot reconstruct discarded transformations; plan corrective rollforward and tested recovery.
This limitation misstates what the feature provides: Recovery needs explicit RPO/RTO, post-backup reconciliation and rehearsal; rollforward may be safer.
This is not the governing limitation because Review application/data contracts and use staged evolution when mixed versions can run during rollout. That assertion removes or misidentifies the relevant residual risk and does not follow from the feature semantics.