Question #1369
A company uses a 150 GB Amazon RDS for MySQL Single-AZ DB instance in the eu-west-1 Region to manage order processing data. The company requires high availability with automatic recovery and needs to address performance degradation caused by quarterly financial audits that run complex queries on the database. Which combination of steps will meet these requirements? (Choose two.)
Convert the DB instance from Single-AZ to Multi-AZ deployment.
Create a snapshot of the DB instance and restore it to a new Multi-AZ deployment in the same Region.
Create a cross-AZ read replica and direct audit queries to the read replica.
Migrate the database to Amazon Aurora with serverless configuration.
Use RDS Proxy to route audit queries during off-peak hours.
Explanation
The correct answers are A and C.
Why A is correct: Converting to Multi-AZ ensures high availability by deploying a standby replica in another Availability Zone (AZ). This enables automatic failover and recovery during outages, meeting the high availability requirement.
Why C is correct: A cross-AZ read replica allows audit queries to run on a separate instance, preventing performance degradation on the primary DB. Read replicas handle read traffic, isolating the primary for critical write operations.
Why others are incorrect:
- B: Restoring from a snapshot is unnecessary; RDS allows direct conversion to Multi-AZ without downtime.
- D: Migrating to Aurora is excessive; the question focuses on RDS MySQL, and Multi-AZ + read replica suffices.
- E: RDS Proxy manages connections but does not offload read queries; a read replica is better suited for audit workloads.
Key Points:
- Use Multi-AZ for high availability and automatic recovery.
- Use read replicas to isolate read-heavy workloads and improve performance.
Answer
The correct answer is: AC