DOP-C02 · Question #470
A company uses Amazon RDS for Microsoft SQL Server as its primary database and must ensure cross-Region high availability with RPO < 1 min and RTO < 10 min. Which solution meets these requirements?
The correct answer is A. Use RDS Multi-AZ DB cluster with cross-Region read replicas. Automate failover via Route 53.. RDS Multi-AZ cluster deployments with cross-Region read replicas support near real-time replication (<1 min RPO) and fast promotion (<10 min RTO). Route 53 CNAME failover redirects application traffic automatically. This is the AWS-recommended DR pattern.
Question
A company uses Amazon RDS for Microsoft SQL Server as its primary database and must ensure cross-Region high availability with RPO < 1 min and RTO < 10 min. Which solution meets these requirements?
Options
- AUse RDS Multi-AZ DB cluster with cross-Region read replicas. Automate failover via Route 53.
- BUse Multi-AZ cluster with snapshots copied cross-Region.
- CUse single-AZ RDS + DMS continuous replication.
- DUse single-AZ with Backup and restore.
How the community answered
(61 responses)- A84% (51)
- B10% (6)
- C2% (1)
- D5% (3)
Explanation
RDS Multi-AZ cluster deployments with cross-Region read replicas support near real-time replication (<1 min RPO) and fast promotion (<10 min RTO). Route 53 CNAME failover redirects application traffic automatically. This is the AWS-recommended DR pattern.
Topics
Community Discussion
No community discussion yet for this question.