SAA-C03 Q684 · Database

Question

A company’s ecommerce website has unpredictable traffic and uses AWS Lambda functions to directly access a private Amazon RDS for PostgreSQL DB instance. The company wants to maintain predictable database performance and ensure that the Lambda invocations do not overload the database with too many connections. What should a solutions architect do to meet these requirements?

Accepted Answer

**Answer B: RDS Proxy endpoint + Lambda inside VPC** satisfies every requirement:

1. **Connection pooling problem**: Lambda functions can scale to thousands of concurrent executions during traffic spikes. Each execution opens a new database connection. PostgreSQL has a finite connection limit (typically a few hundred depending on instance class). Without connection management, the database gets overwhelmed.

2. **RDS Proxy solves connection overload**: RDS Proxy sits between Lambda and RDS, maintaining a **warm pool of persistent connections** to the database. When hundreds of Lambda invocations fire simultaneously, they connect to RDS Proxy, which **multiplexes** these into a much smaller set of actual database connections. This directly addresses 'ensure Lambda invocations do not overlo

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips