Discuss Amazon SAP-C02 Exam Topic 6 Question 4

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.

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

Get Premium SAP-C02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

13 comments · newest first

Earnestine 11 months ago

RDS Proxy sounds like a game changer for this scenario!

Kate 12 months ago

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

Evangelina 12 months ago

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

Ashley 1 year ago

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

Milly 1 year ago

Definitely A and B for better connection management.

Helaine 1 year ago

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

Crista 1 year ago

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

Dino 1 year 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.

Adelina 1 year 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.

Tasia 1 year 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.

Slyvia 1 year ago

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

Dion 1 year ago

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

Doyle 1 year 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.

Amazon SAP-C02 Exam - Topic 6 Question 4 Discussion