Examkin

Question

Difficulty: HardDatabase High Availability

A company runs a critical transactional application in the `us-east-1` Region. The backend database is an Amazon RDS for PostgreSQL DB instance. A SysOps Administrator must configure the database infrastructure to meet the following requirements:

1. Ensure high availability within the primary Region with automatic, zero-downtime failover to a synchronous standby database in the event of an Availability Zone (AZ) outage.
2. Establish a disaster recovery (DR) solution in the `us-west-2` Region with a Recovery Point Objective (RPORPO) of less than 1515 minutes, while allowing reporting tools to query the DR database during normal operations.

Which combination of actions should the SysOps Administrator take to meet these requirements? (Select TWO.)

  1. Modify the primary database instance to enable Multi-AZ deployment.Answer
  2. Create a cross-Region read replica of the database instance in the `us-west-2` Region.Answer
  3. C
    Create a read replica of the database instance in a different Availability Zone in `us-east-1`, and configure Amazon Route 53 failover routing to automatically promote this replica if the primary instance fails.
  4. D
    Deploy a second database instance in the `us-west-2` Region, and configure Amazon Route 53 failover routing to replicate database transactions synchronously between the two Regions.
  5. E
    Configure Amazon Route 53 failover routing to direct write traffic to the database standby instance in the secondary Availability Zone when the primary instance becomes unhealthy.

Answer

To meet the requirements, the SysOps Administrator must modify the primary database instance to enable Multi-AZ deployment and create a cross-Region read replica of the database instance in the secondary Region.
To meet the requirements, the SysOps Administrator must enable Multi-AZ deployment on the primary database instance to ensure high availability and automatic failover within the primary Region. Additionally, creating a cross-Region read replica in the secondary Region supports disaster recovery with a low Recovery Point Objective and allows reporting tools to query the replica without impacting the primary database's performance.

Step-by-Step Solution

1
Analyze the high availability requirement in the primary Region.
Identify that automatic, synchronous, zero-downtime failover within a Region requires an RDS Multi-AZ deployment, where AWS automatically manages DNS updates to the standby replica.
Multi-AZ provides synchronous replication and automatic DNS-level failover without manual intervention.
2
Analyze the disaster recovery and reporting requirements in the secondary Region.
Identify that a cross-Region read replica in the secondary Region satisfies the disaster recovery requirement (asynchronous replication with low latency) and allows read-only reporting traffic.
Read replicas are designed for read scaling (reporting) and cross-Region disaster recovery, offering asynchronous replication.
3
Evaluate and eliminate incorrect configurations involving Route 53 and read replica promotion.
Discard options proposing Route 53 for database replication or for automated read replica promotion, as Route 53 is a DNS routing service and cannot perform database-level operations.
Route 53 does not manage database-level replication or automated failover/promotion of read replicas.

Key Concept

Distinction between RDS Multi-AZ deployments for high availability and Read Replicas (same-region or cross-region) for read scaling and disaster recovery.
Estimated Time:2m 0s
Rate this question

Topics

Database High Availability

More questions from this topic