Amazon Exam SAP-C02 Topic 3 Question 51 Discussion

Actual exam question for Amazon's SAP-C02 exam

Question #: 51
Topic #: 3

A company is running a serverless ecommerce application on AWS. The application uses Amazon API Gateway to invoke AWS Lambda Java functions. The Lambda functions connect to an Amazon RDS for MySQL database to store data.

During a recent sale event, a sudden increase in web traffic resulted in poor API performance and database connection failures. The company needs to implement a solution to minimize the latency for the Lambda functions and to support bursts in traffic.

Which solution will meet these requirements with the LEAST amount of change to the application?

AUpdate the code of the Lambda functions so that the Lambda functions open the database connection outside of the function handler. Increase the provisioned concurrency for the Lambda functions.

BCreate an RDS Proxy endpoint for the database. Store database secrets in AWS Secrets Manager. Set up the required 1AM permissions. Update the Lambda functions to connect to the RDS Proxy endpoint. Increase the provisioned concurrency for the Lambda functions.

CCreate a custom parameter group. Increase the value of the max_connections parameter. Associate the custom parameter group with the RDS DB instance and schedule a reboot. Increase the reserved concurrency for the Lambda functions.

DCreate an RDS Proxy endpoint for the database. Store database secrets in AWS Secrets Manager. Set up the required 1AM permissions. Update the Lambda functions to connect to the RDS Proxy endpoint. Increase the reserved concurrency for the Lambda functions.

Show Suggested Answer

Suggested Answer: B

by Pamella at Mar 09, 2025, 08:54 AM

Limited Time Offer

25%

Off

Get Premium SAP-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Verona

2 months ago

Gotta love those sudden 'sale events' that bring down the whole system. Wish I could get a bonus for that kind of performance.

upvoted 0 times

Junita

1 months ago

B: I agree, it's all about being prepared for those peak times to ensure smooth operation.

upvoted 0 times

...

Devorah

2 months ago

A: Definitely, it's important to have a scalable solution in place for unexpected spikes in traffic.

upvoted 0 times

...

Solange

2 months ago

B: That sounds like a solid solution. It should help with the performance during high traffic.

upvoted 0 times

...

Cherelle

2 months ago

A: B) Create an RDS Proxy endpoint for the database. Store database secrets in AWS Secrets Manager. Set up the required 1AM permissions. Update the Lambda functions to connect to the RDS Proxy endpoint. Increase the provisioned concurrency for the Lambda functions.

upvoted 0 times

...

Anastacia

3 months ago

Haha, 'reserved concurrency' for Lambda? Sounds like a fancy way of saying 'put a cap on it'.

upvoted 0 times

...

Kara

3 months ago

Hold up, why not just increase the max_connections on the RDS instance? Seems like a quick fix to me.

upvoted 0 times

Elroy

1 months ago

C: True, Option B might provide a more comprehensive solution for minimizing latency and handling bursts in traffic.

upvoted 0 times

...

Herman

1 months ago

B: But Option B also includes setting up an RDS Proxy endpoint and using AWS Secrets Manager for database secrets.

upvoted 0 times

...

Hermila

2 months ago

A: Option C suggests increasing the max_connections parameter on the RDS instance.

upvoted 0 times

...

Thersa

3 months ago

Hmm, I see your point. Maybe we should consider all the options before making a decision.

upvoted 0 times

...

Ressie

3 months ago

I agree with Lorita, option B seems like a more comprehensive solution.

upvoted 0 times

...

Graham

3 months ago

I like the idea of increasing the provisioned concurrency for the Lambda functions. That should help handle the traffic spikes.

upvoted 0 times

...

Corazon

3 months ago

Option B seems like the way to go. Using an RDS Proxy and Secrets Manager will help with the connection management and scaling issues.

upvoted 0 times

Caprice

2 months ago

It's a good choice to minimize latency and support bursts in traffic without making too many changes to the application.

upvoted 0 times

...

Sherell

2 months ago

I agree, using RDS Proxy and Secrets Manager will definitely help with the scaling and connection management.

upvoted 0 times

...

Ailene

2 months ago

B) Create an RDS Proxy endpoint for the database. Store database secrets in AWS Secrets Manager. Set up the required 1AM permissions. Update the Lambda functions to connect to the RDS Proxy endpoint. Increase the provisioned concurrency for the Lambda functions.

upvoted 0 times

...