Examkin

Question

Difficulty: EasyDatabase High Availability

A SysOps Administrator needs to configure an Amazon RDS DB instance to ensure automatic failover to a synchronous standby instance in a different Availability Zone during an outage. Which RDS configuration meets this requirement?

  1. Multi-AZ DB deploymentAnswer
  2. B
    RDS Read Replicas in a different Availability Zone
  3. C
    Amazon Route 53 active-passive failover routing policy pointing to a separate standalone DB instance
  4. D
    Cross-Region database replication to another AWS Region

Answer

Multi-AZ DB deployment
The correct option is the Multi-AZ DB deployment because it synchronously replicates data to a standby instance in a different Availability Zone. In the event of an infrastructure failure or primary database outage, Amazon RDS automatically performs a failover to the standby instance by updating the DNS record, ensuring high availability with zero manual intervention.

Step-by-Step Solution

1
Identify the high availability requirement.
The requirement specifies automated database-tier failover to a synchronous standby instance in a different Availability Zone with zero manual intervention.
This limits the potential solutions to AWS services that support synchronous database replication and automated failover.
2
Compare RDS Multi-AZ deployments with Read Replicas.
Multi-AZ deployments perform synchronous replication and automatic DNS-level failover to a standby. Read Replicas perform asynchronous replication and require manual promotion to become the primary instance.
Differentiating these replication and failover mechanisms is key to selecting the highly available solution.
3
Evaluate the DNS-level alternative.
Route 53 active-passive failover routing policies manage traffic routing at the DNS layer but do not configure database synchronization, making them insufficient on their own for database-tier high availability.
This rules out DNS-only failover configurations as a primary database replication solution.

Key Concept

Amazon RDS Multi-AZ deployments provide high availability and failover support for DB instances by synchronously replicating data to a standby instance in a different Availability Zone.
Estimated Time:45s
Rate this question

Topics

Database High Availability

More questions from this topic