AWS Certified Developer – Associate — Question 274

A developer has created an AWS Lambda function that interacts with an Amazon Aurora MySQL database. The Lambda function makes queries to the database. After a performance test for the Lambda function, the database starts to show an error for too many connections.

Which solution will solve this problem with the LEAST operational effort?

Answer options

• A. Create a road replica for the database. Query the replica database instead of the primary database.
• B. Migrate the data to an Amazon DynamoDB database.
• C. Sot a limit to the Lambda function's concurrency.
• D. Create a proxy in Amazon RDS Proxy. Query the proxy instead of the database.

Correct answer: D

Explanation

Amazon RDS Proxy acts as a database connection pooler, which manages and multiplexes connections to the Amazon Aurora MySQL database, preventing the "too many connections" error with minimal operational overhead. Limiting Lambda concurrency (Option C) would restrict throughput and cause throttling, while migrating to DynamoDB (Option B) requires significant code rewriting. Creating a read replica (Option A) does not address connection exhaustion from highly concurrent Lambda scaling.