SAA-C03 Q92 · Database

Question

A company runs a MySQL database on a single Amazon EC2 instance. The company needs to improve availability of the database to prepare for power outages. Which solution will meet this requirement?

Accepted Answer

**Option C: Migrate to Amazon RDS with Multi-AZ deployment**

**Requirement: Improve database availability against power outages.**

A power outage affects an entire Availability Zone (AZ), meaning the EC2 instance and its database become unreachable. To survive this, you need the database running in a **different AZ** with automatic failover.

**How RDS Multi-AZ solves this:**
1. **Synchronous replication**: RDS automatically maintains a standby replica in a different AZ. Every write to the primary is synchronously replicated to the standby before being acknowledged.
2. **Automatic failover**: If the primary AZ experiences a power outage (or any infrastructure failure), RDS automatically promotes the standby to primary — typically within **60-120 seconds**.
3. **No application changes nee

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips