An architecture includes an Amazon API Gateway, AWS Lambda, and Amazon RDS. The Lambda function frequently exhausts the available database connections on the RDS instance during traffic spikes. What is the MOST effective way to resolve this issue without increasing the RDS instance size?

Answer options:

Increase the Lambda concurrent execution limit.

Implement Amazon RDS Proxy between the Lambda function and the RDS instance.

Use Amazon ElastiCache to cache database connections.

Configure the Lambda function to close the connection after every query.

How to approach this question

Identify the connection pooling service for serverless.

Full Answer

B.Implement Amazon RDS Proxy between the Lambda function and the RDS instance.✓ Correct

Implement Amazon RDS Proxy between the Lambda function and the RDS instance.

Amazon RDS Proxy is a fully managed, highly available database proxy that pools and shares database connections, making applications more scalable and resilient to database failures. It is specifically designed to solve the Lambda connection exhaustion problem.

Common mistakes

Increasing Lambda concurrency, which exacerbates the connection limit issue.

Question 64 All questions Question 66

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 7

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is designing a multi-region network architecture connecting 50 AWS accounts a...Hard Q02A company is migrating its hybrid network to AWS. They have two 10 Gbps AWS Direct Connect connec...Hard Q03An enterprise has 100 AWS accounts in AWS Organizations. The security team mandates that all Amaz...Medium Q04A financial company requires that all EBS volumes, S3 buckets, and RDS databases be encrypted usi...Easy Q05An enterprise is designing a disaster recovery strategy for a critical application running on Ama...Hard

View all 75 questions →