SAA-C03 Q611 · Database

Question

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?

Accepted Answer

**Option A: Modify the RDS DB instance to use a Multi-AZ deployment** satisfies every requirement:

1. **Mitigates single point of failure**: Multi-AZ creates a synchronous standby replica in a different Availability Zone. If the primary AZ fails, RDS automatically fails over to the standby — typically within 60-120 seconds.

2. **LEAST implementation effort**: This is a single configuration change on the existing DB instance. You simply modify the DB instance and enable Multi-AZ. AWS handles everything else — provisioning the standby, setting up synchronous replication, and configuring automatic failover. No application code changes, no data migration, no new endpoints.

3. **Applying during the next maintenance window**: This is a best practice. Converting to Multi-AZ involves a brief I/

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips