AWS Certified SysOps Administrator – Associate — Question 326

A company is running an ecommerce application on AWS. The application maintains many open but idle connections to an Amazon Aurora DB cluster. During times of peak usage, the database produces the following error message: "Too many connections." The database clients are also experiencing errors.

Which solution will resolve these errors?

Answer options

• A. Increase the read capacity units (RCUs) and the write capacity units (WCUs) on the database.
• B. Configure RDS Proxy. Update the application with the RDS Proxy endpoint.
• C. Turn on enhanced networking for the DB instances.
• D. Modify the DB cluster to use a burstable instance type.

Correct answer: B

Explanation

Amazon RDS Proxy establishes a database connection pool, allowing applications to pool and share idle database connections, which directly resolves the 'Too many connections' error. RCUs and WCUs are features of Amazon DynamoDB, not Amazon Aurora, making that option incorrect. Enhanced networking and burstable instances do not manage or reduce the number of active database connections, so they will not resolve this issue.