Question 70
An Azure SQL operations team investigates: A hybrid estate needs documented patch status across both SQL Server VMs and managed Azure SQL databases. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (A hybrid estate needs documented patch status across both SQL Server VMs and managed Azure SQL databases.) is: Inventory and maintenance evidence show approved versions, tested failback and healthy application connectivity. It directly tests whether the remediation (Plan supported SQL Server and host patch windows for hybrid or Azure VM deployments and validate application availability after patching.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: A hybrid estate needs documented patch status across both SQL Server VMs and managed Azure SQL databases. The specific supported administrative response is: Plan supported SQL Server and host patch windows for hybrid or Azure VM deployments and validate application availability after patching. The technical risk is: Unplanned SQL or OS updates may restart services and interrupt applications requiring controlled downtime. Confirm the correction with: Inventory and maintenance evidence show approved versions, tested failback and healthy application connectivity.
Incorrect Answers
Azure arc-enabled SQL server inventory (1.1) addresses another technical failure: Without consistent hybrid inventory, patch and configuration state can be missed across data centers. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: Inventory and maintenance evidence show approved versions, tested failback and healthy application connectivity.
Hyperscale storage and growth planning (1.2) would demonstrate or implement: The target tier supports projected data growth and tested query and backup behavior under realistic load. This case instead tests Hybrid SQL server patch planning (1.1); the choice measures or changes another part of the system.
Online migration with minimal downtime (1.3) addresses another technical failure: A one-time copy while writes continue can leave the target behind unless changes are captured until cutover. The required paired action and test concerns Hybrid SQL server patch planning (1.1); a passing result for this alternative could leave that requirement unresolved.