SAA-C03 Q522 · Database

Question

A company has an application that uses a MySQL database that runs on an Amazon EC2 instance. The instance currently runs in a single Availability Zone. The company requires a fault tolerant database solution that provides a recovery time objective (RTO) and a recovery point objective (RPO) of 2 minutes or less. Which solution will meet these requirements?

Accepted Answer

**Option B: Amazon RDS for MySQL with Multi-AZ deployment** meets every requirement:

1. **Fault Tolerance**: Multi-AZ creates a **synchronous standby replica** in a different Availability Zone. If the primary fails, RDS automatically fails over to the standby — no manual intervention or custom scripts needed.

2. **RPO ≤ 2 minutes**: Because replication is **synchronous**, data is written to both the primary and standby before a transaction is acknowledged. This means RPO is effectively **zero** — no data loss on failover.

3. **RTO ≤ 2 minutes**: RDS Multi-AZ automatic failover typically completes in **60–120 seconds** (1–2 minutes). DNS is updated to point to the new primary, and applications reconnect automatically.

4. **Managed Service**: No custom scripts, no manual promotion, no sy

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips