SAA-C03 Q16 · DR

Question

An ecommerce company wants a disaster recovery solution for its Amazon RDS DB instances that run Microsoft SQL Server Enterprise Edition. The company's current recovery point objective (RPO) and recovery time objective (RTO) are 24 hours. Which solution will meet these requirements MOST cost-effectively?

Accepted Answer

**Option D: Copy automatic snapshots to another Region every 24 hours.**

1. **Meets RPO of 24 hours**: RDS creates automatic daily snapshots. Copying these snapshots cross-Region every 24 hours means the maximum data loss is ~24 hours, satisfying the RPO.

2. **Meets RTO of 24 hours**: Restoring an RDS instance from a snapshot in another Region typically takes minutes to a couple of hours depending on size — well within the 24-hour RTO.

3. **Most cost-effective**: You only pay for snapshot storage in the destination Region and the data transfer during the copy. There is **no running DB instance** in the DR Region until you need it. This is a classic **backup & restore** DR strategy — the cheapest tier of disaster recovery.

4. **Native RDS feature**: Cross-Region snapshot copy is a built

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips