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

lambda -> rds-proxy -> aurora replica(s) read-only endpoint https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/ https://aws.amazon.com/about-aws/whats-new/2021/03/amazon-rds-proxy-adds-read-only-endpoints-for-amazon-aurora-replicas/ RDS Data API is used with Aurora Serverless https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html#data-api.limitations

The other options have limitations or do not address the root cause of the issue: Option B (Increasing max_connections): While increasing the maximum number of connections allowed on the DB cluster may provide a temporary solution, it does not address the underlying issue of inefficient connection management, and it may lead to increased resource consumption and potential performance degradation. Option C (Instance scaling): While instance scaling can help increase the overall capacity of the DB cluster, it does not directly address the issue of too many connections being established. Additionally, it may not be effective if the high-traffic periods are unpredictable and short-lived. Option D (RDS Proxy with Aurora Data API): The Aurora Data API is designed for serverless applications to interact with Aurora Serverless databases using a web services model, not for traditional database connections. It does not address the issue of connection management for the existing application architecture.

Option A allows the application to connect to the replica instances without directly accessing them. This approach helps to: 1) Reduce the number of connections to the primary instance 2) Increase performance by offloading read operations to the replica instances 3) Improve reliability by reducing the load on the primary instance during periods of high traffic

Option A

A is ans lambda -> rds-proxy -> aurora replica(s) read-only endpoint

rds-proxy

correct Answer is A