Examkin

Question

Difficulty: MediumDatabase High Availability

A SysOps Administrator is designing the database tier for a new multi-region application. The primary database cluster will run on Amazon Aurora MySQL in the us-east-1 Region. The database must be replicated to the us-west-2 Region to support a disaster recovery plan with a Recovery Point Objective (RPO) of under 5 seconds and a Recovery Time Objective (RTO) of under 2 minutes. The disaster recovery database must also serve read queries for users in the us-west-2 Region. Which configuration will meet these requirements with the least administrative effort?

  1. Configure an Amazon Aurora Global Database with the primary cluster in us-east-1 and a secondary cluster in us-west-2. Direct local read traffic in us-west-2 to the secondary cluster's reader endpoint. In a disaster recovery event, promote the secondary cluster to a standalone primary cluster.Answer
  2. B
    Configure an Amazon Aurora cluster in us-east-1 with Multi-AZ enabled. Create a cross-region Aurora Read Replica in us-west-2. Configure an Amazon Route 53 failover routing policy to automatically promote and route write traffic to the replica in us-west-2 during a failure in us-east-1.
  3. C
    Configure an Amazon Aurora cluster in us-east-1. Set up an AWS Database Migration Service (AWS DMS) task to replicate data to another Aurora cluster in us-west-2. Use Amazon Route 53 latency-based routing to dynamically route write and read traffic between both regions.
  4. D
    Deploy an Amazon RDS for MySQL DB instance in us-east-1 with Multi-AZ enabled. Configure a cross-region Read Replica in us-west-2. Instruct the application in us-west-2 to direct read traffic to the Multi-AZ standby instance in us-east-1 to reduce latency.

Answer

Configure an Amazon Aurora Global Database with the primary cluster in us-east-1 and a secondary cluster in us-west-2. Direct local read traffic in us-west-2 to the secondary cluster's reader endpoint. In a disaster recovery event, promote the secondary cluster to a standalone primary cluster.
The configuration utilizing Amazon Aurora Global Database is correct because it uses dedicated, storage-based replication that delivers an RPO of less than 1 second. The secondary cluster in the us-west-2 Region is fully active for read-only workloads, which directly satisfies the requirement to serve local read queries. In a disaster recovery event, the secondary cluster can be promoted to a standalone primary cluster with a write endpoint in under a minute, comfortably meeting the RTO of under 2 minutes.

Step-by-Step Solution

1
Evaluate the disaster recovery and performance requirements: RPO under 5 seconds, RTO under 2 minutes, and readable databases in the secondary region (us-west-2).
Identify that a solution must support storage-level cross-region replication and fast promotion of the target database.
This establishes the baseline requirements for selecting the appropriate database high availability and replication features.
2
Analyze Amazon Aurora Global Database capabilities.
Confirm that Aurora Global Database features an RPO of less than 1 second, an RTO of under 1 minute for promoting a secondary region, and supports local read-only endpoints in the secondary region.
This shows that the global database configuration natively matches all performance, HA, and DR requirements.
3
Compare against standard RDS Multi-AZ and Route 53 failover limitations.
Determine that Route 53 cannot automate cross-region replica promotion and that standard RDS standby instances cannot accept read requests.
This eliminates incorrect configurations that assume automatic cross-region database promotion via DNS or readable RDS standby nodes.

Key Concept

Amazon Aurora Global Database provides low-latency cross-region replication and fast, manual or automated failover/promotion to secondary clusters, while allowing secondary clusters to serve read-only workloads.
Rate this question

Topics

Database High Availability

More questions from this topic