nerdexam
Amazon

SOA-C02 · Question #687

A company has an ecommerce application. The application runs on Amazon EC2 instances that are in an Auto Scaling group. The company runs a backend PostgreSQL database on Amazon RDS. As the number of…

The correct answer is D. Create an RDS proxy. Configure connectivity to the existing PostgreSQL database. PostgreSQL database. It multiplexes and reuses database connections, dramatically reducing the cost of opening and closing connections as your Auto Scaling group scales out. Because RDS Proxy is managed by AWS and deploys across multiple Availability Zones, it meets the high…

Submitted by renata2k· Mar 30, 2026Cost and Performance Optimization

Question

A company has an ecommerce application. The application runs on Amazon EC2 instances that are in an Auto Scaling group. The company runs a backend PostgreSQL database on Amazon RDS. As the number of EC2 instances increases during times of high application usage, the database’s CPU utilization increases. At the same time, the database’s available memory significantly decreases. A SysOps administrator must reduce the overhead of the new database connections from the Auto Scaling group in a highly available manner. Which solution will meet this requirement?

Options

  • AEnable the RDS Multi-AZ feature.
  • BEnable RDS Performance Insights.
  • CLaunch another EC2 instance. Install and configure PgBouncer with the existing PostgreSQL
  • DCreate an RDS proxy. Configure connectivity to the existing PostgreSQL database.

How the community answered

(21 responses)
  • A
    14% (3)
  • B
    5% (1)
  • C
    5% (1)
  • D
    76% (16)

Explanation

PostgreSQL database. It multiplexes and reuses database connections, dramatically reducing the cost of opening and closing connections as your Auto Scaling group scales out. Because RDS Proxy is managed by AWS and deploys across multiple Availability Zones, it meets the high- availability requirement without additional infrastructure.

Topics

#RDS Proxy#connection pooling#PostgreSQL#Auto Scaling group

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice