SAP-C02 · Question #678
A company has an application that uses an Amazon Aurora PostgreSQL DB cluster for the application's database. The DB cluster contains one small primary instance and three larger replica instances…
The correct answer is A. Use Amazon RDS Proxy to create a proxy for the DB cluster. Configure a read-only endpoint for. 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…
Question
A company has an application that uses an Amazon Aurora PostgreSQL DB cluster for the application's database. The DB cluster contains one small primary instance and three larger replica instances. The application runs on an AWS Lambda function. The application makes many short-lived connections to the database's replica instances to perform read-only operations. During periods of high traffic, the application becomes unreliable and the database reports that too many connections are being established. The frequency of high-traffic periods is unpredictable. Which solution will improve the reliability of the application?
Options
- AUse Amazon RDS Proxy to create a proxy for the DB cluster. Configure a read-only endpoint for
- BIncrease the max_connections setting on the DB cluster's parameter group. Reboot all the
- CConfigure instance scaling for the DB cluster to occur when the DatabaseConnections metric is
- DUse Amazon RDS Proxy to create a proxy for the DB cluster. Configure a read-only endpoint for
How the community answered
(50 responses)- A76% (38)
- B4% (2)
- C14% (7)
- D6% (3)
Explanation
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-
Community Discussion
No community discussion yet for this question.