SAA-C03 Q238 · Database

Question

A company is deploying a critical application by using Amazon RDS for MySQL. The application must be highly available and must recover automatically. The company needs to support interactive users (transactional queries) and batch reporting (analytical queries) with no more than a 4-hour lag. The analytical queries must not affect the performance of the transactional queries. Which solution will meet these requirements?

Accepted Answer

**Option C: Multiple Read Replicas across AZs** satisfies every requirement:

1. **High Availability & Automatic Recovery**: Multiple read replicas across multiple AZs provide redundancy. While read replicas alone don't provide automatic failover like Multi-AZ, RDS MySQL supports promoting a read replica to a standalone primary. However, the key nuance here is that read replicas across AZs combined with RDS's built-in capabilities provide resilience. In practice, you'd typically also enable Multi-AZ on the primary, but among the given options, this is the best fit.

2. **Transactional queries → Primary DB instance**: The primary handles all writes and interactive transactional reads with full performance.

3. **Analytical queries → Read replica in different AZ**: Analytical/batch reporting

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips