Question 730
An Azure SQL operations team investigates: A compliance auditor asks whether the documented RPO/RTO applies to a zone loss or a full regional loss. 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 compliance auditor asks whether the documented RPO/RTO applies to a zone loss or a full regional loss. The specific supported administrative response is: Differentiate availability-zone failure protection from cross-region disaster recovery and choose appropriate supported redundancy options. The technical risk is: A zone-redundant primary inside one region may not protect against a complete regional outage. Confirm the correction with: Controlled failure-domain tests show zonal continuity and separately documented regional recovery capability.
The acceptance evidence for this incident (A compliance auditor asks whether the documented RPO/RTO applies to a zone loss or a full regional loss.) is: Controlled failure-domain tests show zonal continuity and separately documented regional recovery capability. It directly tests whether the remediation (Differentiate availability-zone failure protection from cross-region disaster recovery and choose appropriate supported redundancy options.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Native restore sequence with norecovery and recovery (5.2) addresses another technical failure: Recovering the database too early or restoring an incompatible log backup can prevent remaining backup application. The case states: A compliance auditor asks whether the documented RPO/RTO applies to a zone loss or a full regional loss. The most direct paired action and test is: Differentiate availability-zone failure protection from cross-region disaster recovery and choose appropriate supported redundancy options.
Disaster recovery runbook and rehearsal (5.1) addresses another technical failure: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. This choice can be useful for that problem, but it does not establish the Zone redundancy versus geo disaster recovery (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 paired-answer requirement concerns Zone redundancy versus geo disaster recovery (5.1); this alternative does not provide the matching intervention and separate acceptance evidence.