AWS Certified Developer – Associate (DVA-C02) — Question 195

A developer has created an AWS Lambda function that makes queries to an Amazon Aurora MySQL DB instance. When the developer performs a test, the DB instance shows an error for too many connections.

Which solution will meet these requirements with the LEAST operational effort?

Answer options

• A. Create a read replica for the DB instance. Query the replica DB instance instead of the primary DB instance.
• B. Migrate the data to an Amazon DynamoDB database.
• C. Configure the Amazon Aurora MySQL DB instance for Multi-AZ deployment.
• D. Create a proxy in Amazon RDS Proxy. Query the proxy instead of the DB instance.

Correct answer: D

Explanation

The correct answer is D because Amazon RDS Proxy helps manage database connections efficiently, reducing the load on the database instance. Option A, while it provides a read-only replica, does not address the issue of too many connections effectively. Option B involves a significant migration effort and may not be necessary. Option C increases availability but does not resolve connection limits.