AWS Certified Cloud Practitioner — Question 502

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, ensuring high availability and automatic failover. While multi-Region deployments can assist with disaster recovery, they represent a more complex and costly architecture than what is required for standard high availability. Implementing Amazon SQS queues can help decouple application components and buffer write requests, but it does not address the underlying availability or replication of the database itself.