nerdexam
Amazon

SOA-C02 · Question #745

An application accesses databases that run on an Amazon Aurora PostgreSQL Multi-AZ DB cluster. The application is gaining more users and is experiencing an increased load. A SysOps administrator…

The correct answer is B. Use Amazon RDS Proxy to set up a proxy. Associate the proxy with the DB cluster. Amazon RDS Proxy pools and reuses database connections for Aurora PostgreSQL, reducing overhead from frequent opens/closes and letting many application clients share fewer backend connections - directly improving performance under increased load.

Submitted by klara.se· Mar 30, 2026Cost and Performance Optimization

Question

An application accesses databases that run on an Amazon Aurora PostgreSQL Multi-AZ DB cluster. The application is gaining more users and is experiencing an increased load. A SysOps administrator needs to improve the application performance by pooling and sharing database user connections. Which solution will meet this requirement?

Options

  • AIncrease the IOPS of the DB cluster.
  • BUse Amazon RDS Proxy to set up a proxy. Associate the proxy with the DB cluster.
  • CEnable Enhanced Monitoring on the DB cluster. Move the logs to Amazon CloudWatch.
  • DEnable Performance Insights for 35 days on the DB cluster.

How the community answered

(25 responses)
  • A
    16% (4)
  • B
    72% (18)
  • C
    8% (2)
  • D
    4% (1)

Explanation

Amazon RDS Proxy pools and reuses database connections for Aurora PostgreSQL, reducing overhead from frequent opens/closes and letting many application clients share fewer backend connections - directly improving performance under increased load.

Topics

#RDS Proxy#connection pooling#Aurora PostgreSQL#database performance

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice