SAA-C03 Q102 · Database

Question

A company stores a large dataset for an online advertising business in an Amazon RDS for MySQL DB instance. The company wants to run business reporting queries on the data without affecting write operations to the DB instance. Which solution meets these requirements?

Accepted Answer

**Option A: Deploy RDS read replicas to process the business reporting queries.**

**Requirement 1: Run business reporting queries on the data** → Read replicas are full copies of the primary DB instance that can serve read queries independently. Reporting queries are read-heavy operations (SELECT statements) that are perfectly suited for read replicas.

**Requirement 2: Without affecting write operations** → Read replicas use **asynchronous replication** from the primary instance. All read traffic directed to the replica is handled by its own compute and I/O resources, completely separate from the primary instance. This means the primary instance's CPU, memory, and I/O remain fully available for write operations (INSERT, UPDATE, DELETE).

**How it works:**
1. RDS creates a snapshot of the

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips