nerdexam
Amazon

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…

Submitted by rohit_dlh· Mar 6, 2026Continuous Improvement for Existing Solutions

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)
  • A
    76% (38)
  • B
    4% (2)
  • C
    14% (7)
  • D
    6% (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.

Full SAP-C02 Practice