Question 150
An Azure SQL operations team investigates: A migration plan promises zero downtime without testing its final connection switch or transaction drain. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (A migration plan promises zero downtime without testing its final connection switch or transaction drain.) is: A rehearsal verifies initial load, ongoing synchronization, controlled write freeze and post-cutover consistency. It directly tests whether the remediation (Choose a supported online migration workflow with continuous change synchronization and a controlled cutover when downtime tolerance is low.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: A migration plan promises zero downtime without testing its final connection switch or transaction drain. The specific supported administrative response is: Choose a supported online migration workflow with continuous change synchronization and a controlled cutover when downtime tolerance is low. The technical risk is: A one-time copy while writes continue can leave the target behind unless changes are captured until cutover. Confirm the correction with: A rehearsal verifies initial load, ongoing synchronization, controlled write freeze and post-cutover consistency.
Incorrect Answers
Table partitioning for large tables (1.2) addresses another technical failure: Partitioning without a matching access pattern or maintenance plan can complicate administration without improving queries. This choice can be useful for that problem, but it does not establish the Online migration with minimal downtime (1.3) control being assessed here.
SQL server on azure virtual machines (1.1) would demonstrate or implement: The application passes functional acceptance on the chosen VM while OS patching, storage and backup responsibilities are explicitly assigned. This case instead tests Online migration with minimal downtime (1.3); the choice measures or changes another part of the system.
Offline migration and validated cutover (1.3) addresses another technical failure: Restoring from a single old backup without stopping writes or validation can lose committed changes. The required paired action and test concerns Online migration with minimal downtime (1.3); a passing result for this alternative could leave that requirement unresolved.