SAA-C03 Q159 · Database

Question

An application is experiencing performance issues based on increased demand. This increased demand is on read-only historical records that are pulled from an Amazon RDS-hosted database with custom views and queries. A solutions architect must improve performance without changing the database structure. Which approach will improve performance and MINIMIZE management overhead?

Accepted Answer

**B. Deploy Amazon ElastiCache (Redis OSS) and cache the data for the application.**

Let's map each requirement to the solution:

1. **Read-only historical records** → These are ideal candidates for caching because historical data rarely changes. Once cached, the data remains valid for extended periods, resulting in high cache hit ratios.

2. **Improve performance without changing the database structure** → ElastiCache sits as a caching layer *in front of* RDS. The application checks the cache first; if the data is there (cache hit), it returns instantly without touching RDS. If not (cache miss), it queries RDS, stores the result in the cache, and returns. The RDS database schema, views, and queries remain completely unchanged.

3. **Minimize management overhead** → Amazon ElastiCache is

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips