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

An ecommerce website uses an AWS Lambda function and an Amazon RDS for MySQL database for an order fulfillment service. The service needs to return order confirmation immediately.

During a marketing campaign that caused an increase in the number of orders, the website's operations team noticed errors for “too many connections” from Amazon RDS. However, the RDS DB cluster metrics are healthy. CPU and memory capacity are still available.

What should a developer do to resolve the errors?

Answer options

• A. Initialize the database connection outside the handler function. Increase the max_user_connections value on the parameter group of the DB cluster. Restart the DB cluster.
• B. Initialize the database connection outside the handler function. Use RDS Proxy instead of connecting directly to the DB cluster.
• C. Use Amazon Simple Queue Service (Amazon SQS) FIFO queues to queue the orders. Ingest the orders into the database. Set the Lambda function's concurrency to a value that equals the number of available database connections.
• D. Use Amazon Simple Queue Service (Amazon SQS) FIFO queues to queue the orders. Ingest the orders into the database. Set the Lambda function's concurrency to a value that is less than the number of available database connections.

Correct answer: B

Explanation

The correct answer is B because using RDS Proxy helps manage and pool database connections, reducing the likelihood of hitting the connection limit. Option A suggests increasing max_user_connections, which may not effectively solve the underlying connection management issue. Options C and D propose using SQS, which can help with order processing but do not address the connection limitation directly.