Amazon SAP-C02 Exam - Topic 6 Question 4 Discussion

Actual exam question for Amazon's SAP-C02 exam

Question #: 4
Topic #: 6

A solutions architect has developed a web application that uses an Amazon API Gateway Regional endpoint and an AWS Lambda function. The consumers of the web application are all close to the AWS Region where the application will be deployed. The Lambda function only queries an Amazon Aurora MySQL database. The solutions architect has configured the database to have three read replicas.

During testing, the application does not meet performance requirements. Under high load, the application opens a large number of database connections. The solutions architect must improve the application's performance.

Which actions should the solutions architect take to meet these requirements? (Choose two.)

AUse the cluster endpoint of the Aurora database.

BUse RDS Proxy to set up a connection pool to the reader endpoint of the Aurora database.

CUse the Lambda Provisioned Concurrency feature.

DMove the code for opening the database connection in the Lambda function outside of the event handler.

EChange the API Gateway endpoint to an edge-optimized endpoint.

Show Suggested Answer

Suggested Answer: B, D

Connect to RDS outside of Lambda handler method to improve performance https://awstut.com/en/2022/04/30/connect-to-rds-outside-of-lambda-handler-method-to-improve-performance-en/

Using RDS Proxy, you can handle unpredictable surges in database traffic. Otherwise, these surges might cause issues due to oversubscribing connections or creating new connections at a fast rate. RDS Proxy establishes a database connection pool and reuses connections in this pool. This approach avoids the memory and CPU overhead of opening a new database connection each time. To protect the database against oversubscription, you can control the number of database connections that are created. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html

by Lenna at Dec 24, 2022, 05:30 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Earnestine

4 months ago

RDS Proxy sounds like a game changer for this scenario!

upvoted 0 times

...

Kate

4 months ago

Wait, why would you change the API Gateway endpoint? Seems unnecessary.

upvoted 0 times

...

Evangelina

4 months ago

A is a must! Using the cluster endpoint is key.

upvoted 0 times

...

Ashley

4 months ago

I think D could help too, but not sure if it's enough.

upvoted 0 times

...

Milly

4 months ago

Definitely A and B for better connection management.

upvoted 0 times

...

Helaine

5 months ago

I don't think changing the API Gateway to an edge-optimized endpoint will help with database connections, but I could be wrong.

upvoted 0 times

...

Crista

5 months ago

I practiced a similar question where moving the database connection outside the event handler improved performance. That might be a good option too.

upvoted 0 times

...

Dino

5 months ago

I'm a bit unsure about RDS Proxy. I think it helps with connection pooling, but I can't recall if it's necessary for this scenario.

upvoted 0 times

...

Adelina

5 months ago

I remember discussing the importance of using the cluster endpoint for Aurora to balance the load across replicas. That seems like a solid choice here.

upvoted 0 times

...

Tasia

5 months ago

Okay, I think I've got this. Based on the description, Ted was likely depicting security use cases to identify potential attack scenarios. That seems like the most relevant activity here.

upvoted 0 times

...

Slyvia

5 months ago

This question seems straightforward, but I want to make sure I understand the key concepts around checkpoint/restart procedures before selecting an answer.

upvoted 0 times

...

Dion

5 months ago

Ah, I remember learning about SSL profiles in Citrix - that's got to be the answer here.

upvoted 0 times

...

Doyle

5 months ago

I'm a little confused on how to approach this. Do I need to consider the dual uplinks for the hubs separately, or just the total number of connections? I want to make sure I understand the question fully before answering.

upvoted 0 times

...