SAA-C03 Q594 · Database

Question

A company manages an application that stores data on an Amazon RDS for PostgreSQL Multi-AZ DB instance. High traffic on the application is causing increased latency for many read queries. A solutions architect must improve the performance of the application. Which solution will meet this requirement?

Accepted Answer

**Option C: Create a read replica and serve read traffic from it.**

**Step-by-step reasoning:**

1. **Problem identified:** High traffic is causing increased latency specifically for **read queries**. This is a classic read-scaling problem.

2. **Read replicas solve read-scaling:** An Amazon RDS Read Replica is an asynchronous copy of the primary DB instance. By directing read traffic to one or more read replicas, you **offload read workload** from the primary instance.

3. **How it works:** RDS uses PostgreSQL's native streaming replication to keep the read replica in near-real-time sync with the primary. The application directs SELECT queries to the read replica endpoint, while writes continue going to the primary.

4. **Directly addresses the requirement:** The question specifically sa

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips