Examkin

Question

Difficulty: EasyResilient Database Configurations and High Availability

A company runs a production application on an Amazon RDS for PostgreSQL database instance. The database currently operates in a single Availability Zone. The Solutions Architect needs to modify the database configuration to ensure high availability with automatic failover in the event of an infrastructure failure or Availability Zone outage. Which configuration change will meet these requirements with the least operational effort?

  1. A
    Deploy an RDS Read Replica in a different Availability Zone
  2. B
    Configure a multi-region Pilot Light database environment using AWS Database Migration Service (DMS)
  3. Modify the database instance to enable a Multi-AZ deploymentAnswer
  4. D
    Deploy an RDS Read Replica and configure Route 53 Latency routing to manage failover

Answer

Modify the database instance to enable a Multi-AZ deployment
Modifying the RDS instance to a Multi-AZ deployment is the correct answer. AWS automatically provisions a standby replica in a different Availability Zone, synchronously replicates data to it, and performs automatic failover in the event of an outage by updating the DNS record of the database endpoint.

Step-by-Step Solution

1
Identify the primary requirement: high availability with automatic failover for an Amazon RDS database.
Limits the viable options to AWS services that support automatic DNS redirection and failover.
The scenario requires zero manual intervention during an outage.
2
Evaluate the difference between Multi-AZ deployments and Read Replicas.
Multi-AZ uses synchronous replication with automated failover, while Read Replicas use asynchronous replication for scaling reads.
Promoting a Read Replica requires manual promotion or complex scripting, which does not provide native automatic failover.
3
Select Multi-AZ deployment as the solution.
Enabling Multi-AZ achieves synchronous replication and automatic failover with the least operational effort.
AWS manages the replication and failover process natively without additional user configuration.

Key Concept

Amazon RDS Multi-AZ deployments for high availability and automatic failover
Rate this question

Topics

Resilient Database Configurations and High Availability

More questions from this topic