Home › Azure AZ-305 › cloudcomputing › az305datastorage › Which Azure SQL Database feature should an archi…
Which Azure SQL Database feature should an architect recommend to recover from a regional outage with RTO ≤ 1 hour and RPO ≤ 5 seconds for a critical OLTP workload?
AActive geo-replication or auto-failover groups (cross-region readable secondaries)
BAzure DNS failover only
CSnowball-style offline backups
DSingle-region with no cross-region replication
Answer & Solution
Correct answer: A. Active geo-replication or auto-failover groups (cross-region readable secondaries)
Active geo-replication + auto-failover groups give near-zero RPO across regions (per AZ-305 §2 data protection + §3 BCDR). The others can't hit those targets.
Related questions
Which Azure data-platform service should an architect recommend for streaming ingestion + Which Cosmos DB consistency level should an architect recommend for a globally-deployed apWhich Azure storage replication option should an architect recommend for data that must suWhich Azure storage capability should an architect recommend to provide a hierarchical-namWhich Azure service should an architect recommend to ingest, transform, and orchestrate ETWhich Azure service should an architect recommend for petabyte-scale columnar analytics + Which Azure SQL Database feature should an architect recommend to scale a transactional daWhich Cosmos DB feature should an architect recommend to handle a sudden burst from 100 to