SAA-C03 Q599 · Database

Question

A solutions architect has created an AWS Lambda function that makes queries to an Amazon Aurora MySQL DB instance. When the solutions architect performs a test, the DB instance shows an error for too many connections. Which solution will meet these requirements with the LEAST operational effort?

Accepted Answer

**D. Create a proxy in Amazon RDS Proxy. Query the proxy instead of the DB instance.**

**Root Cause Understanding:**
AWS Lambda functions scale horizontally — each concurrent invocation creates a separate execution environment. Each environment opens its own database connection. Unlike traditional application servers with a fixed connection pool, Lambda can spin up hundreds or thousands of concurrent connections rapidly, easily exhausting the database's `max_connections` limit.

**Why RDS Proxy solves this perfectly:**
1. **Connection Pooling**: RDS Proxy maintains a pool of established connections to the database. Instead of each Lambda invocation creating a new DB connection, they connect to the proxy, which multiplexes many client connections over fewer database connections.
2. **Conne

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips