SAP-C02 Q76 · DR

Question

A retail company is hosting an ecommerce website on AWS across multiple AWS Regions. The company wants the website to be operational at all times for online purchases. The website stores data in an Amazon RDS for MySQL DB instance. Which solution will provide the HIGHEST availability for the database?

Accepted Answer

**Option D** provides the highest availability through cross-Region read replicas with a clear promotion strategy:

1. **Cross-Region Read Replicas**: RDS for MySQL supports cross-Region read replicas that asynchronously replicate data from the primary DB instance in one Region to a replica in another Region. This gives you a **near-real-time copy** of your data in a different Region.

2. **Promotion on Disruption**: If the primary Region fails, you can **promote the cross-Region read replica to a standalone DB instance**. This promotion process is fast — it breaks replication and makes the replica a fully writable, independent database.

3. **Traffic Redirection**: After promotion, you redirect your application's database traffic to the newly promoted DB instance in the surviving Region.

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips