Question 30
An Azure SQL operations team investigates: An existing SQL Server deployment uses custom operating-system integrations that need to remain intact in Azure. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (An existing SQL Server deployment uses custom operating-system integrations that need to remain intact in Azure.) is: The application passes functional acceptance on the chosen VM while OS patching, storage and backup responsibilities are explicitly assigned. It directly tests whether the remediation (Use SQL Server on Azure Virtual Machines when the workload requires operating-system control or specialized instance configurations unavailable in managed offerings.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: An existing SQL Server deployment uses custom operating-system integrations that need to remain intact in Azure. The specific supported administrative response is: Use SQL Server on Azure Virtual Machines when the workload requires operating-system control or specialized instance configurations unavailable in managed offerings. The technical risk is: Moving an OS-dependent SQL workload to PaaS may remove administrative capabilities it requires. Confirm the correction with: The application passes functional acceptance on the chosen VM while OS patching, storage and backup responsibilities are explicitly assigned.
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: The application passes functional acceptance on the chosen VM while OS patching, storage and backup responsibilities are explicitly assigned.
Azure SQL managed instance compatibility (1.1) addresses another technical failure: Selecting single-database PaaS for SQL Agent or instance-centered dependencies creates costly compatibility rework. This case instead tests SQL server on azure virtual machines (1.1); the choice measures or changes another part of the system.
Azure SQL database elastic pools (1.2) would demonstrate or implement: Pool and per-database resource metrics demonstrate the expected concurrency without sustained saturation. The paired-answer requirement concerns SQL server on azure virtual machines (1.1); this alternative does not provide the matching intervention and separate acceptance evidence.