Examkin

Question

Difficulty: MediumDatabase High Availability

A logistics startup runs its tracking application on an Amazon RDS for PostgreSQL DB instance in a single Availability Zone (AZ). Due to strict business continuity requirements, a SysOps Administrator must convert this database to a highly available deployment to ensure automatic failover in the event of an AZ outage. The migration must minimize downtime during implementation, and the application must automatically connect to the new database instance after failover without manual updates to the connection configuration. Which two steps should the SysOps Administrator take to meet these requirements? (Select TWO.)

  1. Modify the DB instance to enable the Multi-AZ deployment option, which provisions a synchronous standby replica in a different Availability Zone.Answer
  2. Keep the existing database endpoint in the application configuration, as Amazon RDS automatically updates the DNS record to point to the standby replica during failover.Answer
  3. C
    Configure an Amazon Route 53 active-passive failover routing policy with health checks pointing to the primary DB instance and a standby replica to manage the DNS redirection.
  4. D
    Create an Amazon RDS Read Replica in another Availability Zone, and configure the application to perform automated failover directly to the read replica's endpoint.

Answer

To establish database high availability with automatic failover, the SysOps Administrator must modify the DB instance to enable the Multi-AZ deployment option, which creates a synchronous standby replica in a different Availability Zone. The application should keep using the existing database endpoint since Amazon RDS automatically updates the DNS CNAME record to point to the promoted standby instance during a failover event.
To configure high availability with automatic failover, the database must be converted to a Multi-AZ deployment. This creates a standby replica in another Availability Zone with synchronous replication. When a failover occurs, Amazon RDS automatically updates the CNAME of the database endpoint to point to the standby instance. Thus, the application configuration does not need any database endpoint updates.

Step-by-Step Solution

1
Enable the Multi-AZ option on the existing single-AZ RDS DB instance.
Amazon RDS automatically provisions a standby replica in a different Availability Zone and replicates the data synchronously.
This establishes the required high availability configuration to survive Availability Zone failures.
2
Retain the current connection endpoint in the application config.
The application targets the same database endpoint without manual connection string updates.
Amazon RDS manages DNS failover internally by updating the CNAME record of the DB instance endpoint to resolve to the standby instance during an outage.

Key Concept

Amazon RDS Multi-AZ deployments provide high availability and automatic failover by using synchronous replication to a standby replica in a different Availability Zone and updating the DNS CNAME record automatically during failover.
Rate this question

Topics

Database High Availability

More questions from this topic