Question 160
An Azure SQL operations team investigates: A project marks the cloud migration complete before testing row counts, schema objects and connectivity. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (A project marks the cloud migration complete before testing row counts, schema objects and connectivity.) is: Post-migration row and schema checks, integrity checks, and application tests pass before source retirement. It directly tests whether the remediation (Use a supported offline database migration or backup-and-restore workflow when a planned write outage is acceptable and validate target compatibility.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: A project marks the cloud migration complete before testing row counts, schema objects and connectivity. The specific supported administrative response is: Use a supported offline database migration or backup-and-restore workflow when a planned write outage is acceptable and validate target compatibility. The technical risk is: Restoring from a single old backup without stopping writes or validation can lose committed changes. Confirm the correction with: Post-migration row and schema checks, integrity checks, and application tests pass before source retirement.
Incorrect Answers
Azure SQL migration readiness assessment (1.3) addresses another technical failure: Choosing a target from server size alone can miss unsupported features and production performance needs. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: Post-migration row and schema checks, integrity checks, and application tests pass before source retirement.
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 choice can be useful for that problem, but it does not establish the Offline migration and validated cutover (1.3) control being assessed here.
Azure SQL database platform fit (1.1) addresses another technical failure: Moving an application with unsupported instance dependencies to a logical database can break its procedures or operations. The required paired action and test concerns Offline migration and validated cutover (1.3); a passing result for this alternative could leave that requirement unresolved.