AWS Certified Solutions Architect – Associate (SAA-C03) — Question 884

A company hosts an ecommerce application that stores all data in a single Amazon RDS for MySQL DB instance that is fully managed by AWS. The company needs to mitigate the risk of a single point of failure.

Which solution will meet these requirements with the LEAST implementation effort?

Answer options

• A. Modify the RDS DB instance to use a Multi-AZ deployment. Apply the changes during the next maintenance window.
• B. Migrate the current database to a new Amazon DynamoDB Multi-AZ deployment. Use AWS Database Migration Service (AWS DMS) with a heterogeneous migration strategy to migrate the current RDS DB instance to DynamoDB tables.
• C. Create a new RDS DB instance in a Multi-AZ deployment. Manually restore the data from the existing RDS DB instance from the most recent snapshot.
• D. Configure the DB instance in an Amazon EC2 Auto Scaling group with a minimum group size of three. Use Amazon Route 53 simple routing to distribute requests to all DB instances.

Correct answer: A

Explanation

Modifying an existing Amazon RDS instance to a Multi-AZ deployment is a simple configuration change that AWS handles automatically, making it the solution with the least implementation effort. Migrating to DynamoDB (Option B) would require significant application refactoring and data schema changes, while manually restoring from a snapshot (Option C) creates unnecessary downtime and operational steps compared to an in-place modification. Running RDS instances inside an EC2 Auto Scaling group (Option D) is not a supported or valid architectural pattern for Amazon RDS.