Examkin

Question

Difficulty: MediumResilient Database Configurations and High Availability

A healthcare software provider is deploying a critical patient portal application on AWS. The application database tier requires high availability within the primary Region (us-east-1) to survive the loss of an Availability Zone with a Recovery Time Objective (RTO) of under 60 seconds. Additionally, the provider requires a cross-region disaster recovery (DR) solution in the us-west-2 Region with a Recovery Point Objective (RPO) of under 1 minute and a Recovery Time Objective (RTO) of under 15 minutes. Which combination of database configurations will meet these requirements? (Select TWO.)

  1. Deploy an Amazon Aurora PostgreSQL DB cluster in us-east-1 with at least one Aurora Replica in a different Availability Zone.Answer
  2. Use Amazon Aurora Global Databases to replicate data from us-east-1 to a secondary Aurora DB cluster in us-west-2.Answer
  3. C
    Configure a single-AZ Amazon RDS for PostgreSQL DB instance in us-east-1 and set up an active-passive cross-Region Read Replica in us-west-2 for primary database failover.
  4. D
    Configure a Multi-AZ Amazon RDS for PostgreSQL DB instance in us-east-1, and use Amazon Route 53 latency routing to dynamically route database write requests between us-east-1 and us-west-2.
  5. E
    Deploy an Amazon RDS for PostgreSQL DB instance in us-east-1, and configure a Pilot Light recovery structure in us-west-2 by keeping a scaled-down RDS instance running and synchronizing it via daily snapshot copying.

Answer

Deploy an Amazon Aurora PostgreSQL DB cluster in us-east-1 with at least one Aurora Replica in a different Availability Zone, and use Amazon Aurora Global Databases to replicate data from us-east-1 to a secondary Aurora DB cluster in us-west-2.
Deploying an Amazon Aurora DB cluster with an Aurora Replica in a different Availability Zone provides automatic failover in under 30 seconds, satisfying the regional high availability RTO requirement of under 60 seconds. Combining this with Amazon Aurora Global Databases allows storage-level, low-latency replication to a secondary Region with a lag of less than 1 second (satisfying the 1-minute RPO) and enabling promotion of the secondary cluster in less than 1 minute (satisfying the 15-minute RTO).

Step-by-Step Solution

1
Analyze the regional high availability constraint (RTO < 60 seconds in us-east-1).
Identify that a Multi-AZ deployment is required. An Amazon Aurora PostgreSQL DB cluster with at least one replica in a separate Availability Zone provides automatic failover in under 30 seconds, meeting the target.
Single-AZ deployments or manual replica promotions do not meet the low RTO requirement for regional Availability Zone failures.
2
Analyze the cross-region disaster recovery constraints (RPO < 1 minute, RTO < 15 minutes in us-west-2).
Select Amazon Aurora Global Databases, which use fast storage-level replication with lag under 1 second (meeting the RPO of under 1 minute) and support failover/promotion in minutes (meeting the RTO of under 15 minutes).
Daily snapshot replication (Pilot Light) results in an RPO of 24 hours, which violates the 1-minute RPO limit.

Key Concept

High availability and disaster recovery design using Amazon Aurora Multi-AZ and Aurora Global Databases
Estimated Time:2m 0s
Rate this question

Topics

Resilient Database Configurations and High Availability

More questions from this topic