AWS Certified Cloud Practitioner — Question 552
A company has a business-critical Amazon RDS for MySQL DB instance that resides in a single Availability Zone.
Which solution will improve the availability of the DB instance?
Answer options
- A. Convert the DB instance into a multi-Region deployment.
- B. Create an Amazon Simple Queue Service (Amazon SQS) queue in the same AWS Region to manage writes to the DB instance.
- C. Convert the DB instance into a Multi-AZ deployment.
- D. Create an Amazon Simple Queue Service (Amazon SQS) queue in a different AWS Region to manage writes to the DB instance.
Correct answer: C
Explanation
Converting an Amazon RDS DB instance to a Multi-AZ deployment automatically provisions and maintains a synchronous standby replica in a different Availability Zone, providing high availability and automatic failover. While Amazon SQS can decouple database writes, it does not directly improve the availability of the RDS instance itself. Multi-Region deployments are typically used for disaster recovery rather than standard high availability, making Multi-AZ the most direct and effective solution.