Q4 — AWS SAA-C03 Ch.14

Question 4 of 100 | ← Chapter 14

Q1004. 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?

• 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. Modify the RDS DB instance to use a Multi-AZ deployment. Apply the changes during the next maintenance window.

Explanation

To mitigate the risk of a single point of failure for an Amazon RDS for MySQL DB instance with the least implementation effort, the best solution is:A. Modify the RDS DB instance to use a Multi-AZ deployment. Apply the changes during the next maintenance window.Explanation:Multi-AZ Deployment: By modifying the existing RDS instance to use Multi-AZ, AWS automatically provisions a synchronous standby replica in a different Availability Zone. In case of a failure of the primary DB instance, the standby can be promoted to primary with minimal downtime. This solution requires the least effort because it utilizes the existing RDS instance and infrastructure.Evaluation of Other Options:B. Migrate the current database to a new Amazon DynamoDB Multi-AZ deployment: This option involves a complete migration to a different database technology (DynamoDB), which requires significant effort, planning, and potential changes to the application logic.C. Create a new RDS DB instance in a Multi-AZ deployment: While this option could work, it requires manually restoring data from the existing instance, which adds complexity and implementation effort compared to simply modifying the current instance.D. Configure the DB instance in an Amazon EC2 Auto Scaling group: This approach is complex and not suited for RDS, as RDS does not work in an Auto Scaling group environment like EC2. Managing multiple RDS instances in this way would require significant effort to ensure consistency and reliability.In summary, Option A is the most efficient and effective solution for enhancing the availability of the RDS database with minimal implementation effort.