AWS Certified Database – Specialty — Question 57

A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?

Answer options

• A. Edit the my.cnf file for the DB cluster to increase max_connections
• B. Increase the instance size of the DB cluster
• C. Change the DB cluster to Multi-AZ
• D. Increase the number of Aurora Replicas

Correct answer: B

Explanation

Increasing the instance size of the DB cluster (B) provides more resources to handle the increased number of concurrent connections from the Lambda functions. Editing the my.cnf file to increase max_connections (A) may help, but if the instance size is not sufficient, it would still not resolve the issue. Changing to Multi-AZ (C) improves availability but does not directly address connection limits, and adding more Aurora Replicas (D) helps with read scaling but does not increase the connection capacity of the primary instance.