Question 720
An Azure SQL operations team investigates: An HA design is approved based on uptime percentage alone without assessing recovery-point requirements. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (An HA design is approved based on uptime percentage alone without assessing recovery-point requirements.) is: A failure rehearsal measures actual recovery time and data divergence against documented RTO and RPO targets. It directly tests whether the remediation (Choose supported SQL high-availability and disaster-recovery features according to explicit recovery point and recovery time objectives and business criticality.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: An HA design is approved based on uptime percentage alone without assessing recovery-point requirements. The specific supported administrative response is: Choose supported SQL high-availability and disaster-recovery features according to explicit recovery point and recovery time objectives and business criticality. The technical risk is: A design with acceptable availability but unknown possible data loss can violate agreed recovery commitments. Confirm the correction with: A failure rehearsal measures actual recovery time and data divergence against documented RTO and RPO targets.
Incorrect Answers
Zone redundancy versus geo disaster recovery (5.1) addresses another technical failure: A zone-redundant primary inside one region may not protect against a complete regional outage. This choice can be useful for that problem, but it does not establish the Ha dr design from rpo and rto (5.1) control being assessed here.
Monitoring replica health and lag across ha dr (5.3) addresses another technical failure: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. This case instead tests Ha dr design from rpo and rto (5.1); the choice measures or changes another part of the system.
Automated point-in-time restore for azure SQL (5.2) would demonstrate or implement: The restored database contains records consistent with the selected timestamp and application validation passes. The required paired action and test concerns Ha dr design from rpo and rto (5.1); a passing result for this alternative could leave that requirement unresolved.