Question 750
An Azure SQL operations team investigates: An auditor requests evidence that recovery procedures are executable within the stated business time limit. 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: An auditor requests evidence that recovery procedures are executable within the stated business time limit. The specific supported administrative response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. The technical risk is: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. Confirm the correction with: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.
The acceptance evidence for this incident (An auditor requests evidence that recovery procedures are executable within the stated business time limit.) is: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap. It directly tests whether the remediation (Document and regularly test supported failover, failback, application validation, ownership and communication procedures.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Hybrid SQL server dr topology planning (5.1) addresses another technical failure: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. This choice can be useful for that problem, but it does not establish the Disaster recovery runbook and rehearsal (5.1) control being assessed here.
Azure SQL database active geo-replication (5.3) would demonstrate or implement: Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations. The required paired action and test concerns Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.
SQL server failover cluster instances on azure vms (5.3) addresses another technical failure: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. The paired-answer requirement concerns Disaster recovery runbook and rehearsal (5.1); this alternative does not provide the matching intervention and separate acceptance evidence.