SAA-C03 Q114 · Database

Question

A company is designing an application to connect AWS Lambda functions to an Amazon RDS for MySQL DB instance. The DB instance manages many connections. The company needs to modify the application to improve connectivity and recovery. Which solution will meet these requirements with the LEAST operational overhead?

Accepted Answer

**Option A: Use Amazon RDS Proxy** is correct for several critical reasons:

1. **Connection Pooling Problem**: Lambda functions are ephemeral — each invocation can open a new database connection. Under high concurrency, hundreds or thousands of Lambda invocations can exhaust the DB instance's maximum connection limit. This is the classic Lambda-to-RDS anti-pattern.

2. **RDS Proxy solves this directly**: RDS Proxy sits between Lambda and the RDS instance, maintaining a warm pool of persistent database connections. Multiple Lambda invocations share these pooled connections, dramatically reducing the total number of connections to the DB instance.

3. **Improved recovery**: RDS Proxy automatically handles failover scenarios. During a DB failover (e.g., Multi-AZ switchover), RDS Proxy transp

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips