Examkin

Question

Difficulty: MediumDatabase High Availability

A healthcare application uses an Amazon RDS for MySQL DB instance in a Single-AZ deployment. The database suffers from high CPU utilization due to a mix of transactional writes and read-intensive reporting queries. A SysOps Administrator must configure the database architecture to support automatic failover in the event of an Availability Zone outage and isolate the reporting workload from the transactional write operations. Which deployment strategy will satisfy these requirements?

  1. Enable the Multi-AZ feature on the DB instance. Create an RDS Read Replica in a different Availability Zone, and configure the reporting queries to use the Read Replica endpoint.Answer
  2. B
    Create an RDS Read Replica in a different Availability Zone. Configure an Amazon Route 53 failover routing policy to redirect transactional write traffic to the Read Replica if the primary DB instance fails.
  3. C
    Enable the Multi-AZ feature on the DB instance. Identify the private DNS endpoint of the standby replica in the secondary Availability Zone, and configure the reporting workload to query that endpoint.
  4. D
    Create a read-writable RDS replica using Multi-Region replication. Configure Amazon Route 53 active-active routing to distribute both write and read traffic equally between the primary database and the replica.

Answer

Enable the Multi-AZ feature on the DB instance. Create an RDS Read Replica in a different Availability Zone, and configure the reporting queries to use the Read Replica endpoint.
The correct solution involves enabling Multi-AZ on the database to ensure automatic failover and high availability, while creating a separate Read Replica to handle the reporting workload. In an RDS Multi-AZ deployment, replication to the standby replica is synchronous, but the standby replica is passive and cannot accept read queries. Therefore, to offload reporting queries, a separate Read Replica must be created.

Step-by-Step Solution

1
Analyze the database requirements: automatic failover for high availability and workload isolation for read-intensive reporting queries.
Identify that Multi-AZ provides synchronous replication and automatic failover, while Read Replicas provide asynchronous replication and read scaling.
To ensure transactional safety and high availability, Multi-AZ is required. To isolate read workloads, a separate readable endpoint is required because Multi-AZ standby instances are passive and cannot be read from.
2
Evaluate the proposed solutions against Amazon RDS capabilities.
The correct solution uses Multi-AZ for failover and a Read Replica for reporting queries.
This aligns with AWS best practices for scaling reads while maintaining a high availability posture.

Key Concept

Distinction between RDS Multi-AZ deployments for high availability and RDS Read Replicas for read scaling and workload isolation.
Estimated Time:1m 30s
Rate this question

Topics

Database High Availability

More questions from this topic