Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 48 discussion

The correct answer is B and D. B. Using RDS Proxy to set up a connection pool to the reader endpoint of the Aurora database can help improve the performance of the application by reducing the number of connections opened to the database. RDS Proxy manages the connection pool and routes incoming connections to the available read replicas, which can help with connection management and reduce the number of connections that need to be opened and closed. D. Moving the code for opening the database connection in the Lambda function outside of the event handler can help to improve the performance of the application by allowing the database connection to be reused across multiple requests. This avoids the need to open and close a new connection for each request, which can be time-consuming and resource-intensive.

B. Use RDS Proxy to set up a connection pool to the reader endpoint of the Aurora database. D. Move the code for opening the database connection in the Lambda function outside of the event handler.

The issue is with the number of database connections, thee are the only two changes that would impact the number of concurrent DB connections.

B and D

B. Use RDS Proxy to set up a connection pool to the reader endpoint of the Aurora database. RDS Proxy helps manage and efficiently pool database connections, reducing the number of database connections required by the application. It helps improve performance and reduces the load on the database. D. Move the code for opening the database connection in the Lambda function outside of the event handler. By reusing database connections, you can reduce the overhead of opening and closing connections for each Lambda invocation. You can use the Lambda execution context to keep the database connection open and reuse it across multiple requests within the same execution context.

BD for sure

RDS proxy + Lambda function

RDX proxy & connecting outside the handler method is up to 5 times faster than connecting inside.

he Lambda function only queries an Amazon Aurora MySQL database- so i would reject option C

This may be too logical answer :-) - Setting up RDS proxy will help connection pooling, So B is one answer. Now C vs D This question focuses on serverless solutions and best practices of lambda. and question hints that lambda only contains simple code.so lambda concurrency improvements may not be be the cause for performance issues detected while testing, and guess what - app is still in testing phase. so code might have a flaw can be reviewed and changed as per lambda best practices - https://docs.aws.amazon.com/lambda/latest/dg/best-practices.html. I choose B and D

According to ChatGPT, By reusing the same database connection across multiple invocations of the function, you can reduce the number of database connections that are opened and closed, which can help conserve resources and reduce the risk of running into database connection limits.

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

B/C lambda provisioned concurrency and RDS proxy are mentioned in same page. https://quintagroup.com/blog/aws-lambda-provisioned-concurrency

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.howitworks.html https://docs.aws.amazon.com/lambda/latest/dg/provisioned-concurrency.html

B/C Provisioned Concurrency needed: https://www.reddit.com/r/aws/comments/gcwtqt/lambda_provisioned_concurrency_with_aurora/ With connection Pool, no to worry D