Question 140
An Azure SQL operations team investigates: A project plans to shut down source servers before inventorying database cross-dependencies. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The reported Azure SQL or SQL Server condition is: A project plans to shut down source servers before inventorying database cross-dependencies. The specific supported administrative response is: Assess existing SQL Server dependencies, compatibility and workload utilization before selecting Azure SQL Database, Managed Instance or Azure VM. The technical risk is: Choosing a target from server size alone can miss unsupported features and production performance needs. Confirm the correction with: The readiness report lists blockers, target recommendations, right-sizing evidence and a remediation owner.
The acceptance evidence for this incident (A project plans to shut down source servers before inventorying database cross-dependencies.) is: The readiness report lists blockers, target recommendations, right-sizing evidence and a remediation owner. It directly tests whether the remediation (Assess existing SQL Server dependencies, compatibility and workload utilization before selecting Azure SQL Database, Managed Instance or Azure VM.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Columnstore and row compression decisions (1.2) would demonstrate or implement: Before-and-after size, CPU and representative query tests establish the net benefit of the selected compression. The case states: A project plans to shut down source servers before inventorying database cross-dependencies. The most direct paired action and test is: Assess existing SQL Server dependencies, compatibility and workload utilization before selecting Azure SQL Database, Managed Instance or Azure VM.
Hybrid SQL server patch planning (1.1) addresses another technical failure: Unplanned SQL or OS updates may restart services and interrupt applications requiring controlled downtime. This case instead tests Azure SQL migration readiness assessment (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 paired-answer requirement concerns Azure SQL migration readiness assessment (1.3); this alternative does not provide the matching intervention and separate acceptance evidence.