nerdexam
Amazon

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.

Submitted by jian89· Mar 6, 2026Reliability & Resilience

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)
  • A
    84% (51)
  • B
    10% (6)
  • C
    2% (1)
  • D
    5% (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

#RDS#High Availability#Disaster Recovery#RPO/RTO

Community Discussion

No community discussion yet for this question.

Full DOP-C02 Practice