SAA-C03 Q544 · Database

Question

A company has a production Amazon RDS for MySQL database. The company needs to create a new application that will read frequently changing data from the database with minimal impact on the database's overall performance. The application will rarely perform the same query more than once. What should a solutions architect do to meet these requirements?

Accepted Answer

**Option C: Set up a read replica for the database. Query the read replica.**

Let's map each requirement to the solution:

1. **Read frequently changing data** → A read replica uses asynchronous replication from the primary database, so it continuously receives the latest data changes. The data on the replica stays nearly real-time (typically seconds of lag).

2. **Minimal impact on the database's overall performance** → Read replicas offload read traffic entirely to a separate database instance. The new application's queries hit the replica, not the primary, so the production workload is protected.

3. **Rarely performs the same query more than once** → This is the critical clue that eliminates caching. Since queries are rarely repeated, a cache would have an extremely low hit rate, maki

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips