Examkin

Question

Difficulty: MediumDatabase High Availability

A SysOps Administrator is managing a business-critical application that currently uses a single-instance Amazon RDS for MySQL DB instance. The database needs to be upgraded to support high availability with automatic failover to minimize downtime during unplanned outages. Additionally, the reporting team needs to run daily query-intensive reports without impacting the performance of the write operations on the primary database. Which combination of actions will meet these requirements? (Select TWO.)

  1. Modify the DB instance to enable Multi-AZ deployment, creating a synchronous standby instance in a different Availability Zone.Answer
  2. Create an RDS Read Replica and configure the reporting application to direct queries to the read replica endpoint.Answer
  3. C
    Configure Amazon Route 53 with a failover routing policy that points to a Read Replica, designating it as the primary failover target.
  4. D
    Enable Multi-AZ deployment and configure the reporting application to read directly from the standby instance's endpoint.
  5. E
    Configure the DB instance to perform synchronous replication to an RDS Read Replica, allowing it to serve as the automatic failover target.

Answer

Modifying the DB instance to enable Multi-AZ deployment and creating an RDS Read Replica to offload reporting queries are the correct actions.
To achieve database high availability with automatic failover, the SysOps Administrator must enable Multi-AZ deployment, which replicates data synchronously to a standby instance in a different Availability Zone. To handle query-intensive reports without affecting the primary write performance, the administrator must create an RDS Read Replica and route the read traffic to its endpoint.

Step-by-Step Solution

1
Identify high availability requirements.
The primary database requires high availability with automatic failover to minimize downtime.
Unplanned outages can be mitigated by RDS Multi-AZ deployments, which automatically fail over to a synchronous standby.
2
Identify reporting query requirements.
The reporting queries must be offloaded to avoid performance impact on write operations.
RDS Read Replicas are designed to handle read-heavy workloads and operate independently of the primary instance's write workload.
3
Eliminate options that use incorrect failover or read methods.
Options proposing reading from the Multi-AZ standby, using Route 53 failover for read replicas, or configuring synchronous replication to a read replica are incorrect.
Standby instances are passive and inaccessible; read replicas are asynchronous and do not support automatic failover via DNS routing policies.

Key Concept

Database High Availability
Estimated Time:2m 0s
Rate this question

Topics

Database High Availability

More questions from this topic