ExamPark
Course menuSOA-C03

Exams / SOA-C03 / RDS performance monitoring / Question 1

SOA-C03 practice question: RDS performance monitoring

Monitoring, Logging, Analysis, Remediation, and Performance Optimization A free question from our original SOA-C03 practice exam. Try it, then open the answer to see why each option is right or wrong.

Last verified against current AWS documentation ·How we write our questions

A pet insurer's claims intake uses AWS Lambda functions that write to an Amazon RDS for PostgreSQL DB instance.

During a marketing campaign, thousands of functions ran at once and the database rejected new connections with too many clients errors, although CPU stayed below 40 percent.

The team wants to absorb these bursts without changing the database engine or the instance size.

What should a CloudOps engineer do?

Choose one answer.

  1. A. Create a read replica and point half of the Lambda functions at it so that connections are split across two instances.
  2. B. Raise max_connections in the DB parameter group to the highest value allowed so that the instance accepts every connection.
  3. C. Put an RDS Proxy in front of the DB instance and have the Lambda functions connect to the proxy endpoint instead.
  4. D. Turn on Performance Insights and find the SQL statements that hold connections the longest, then tune them.
Show the answer and explanation

Answer: C

Explanation

Serverless clients open many short-lived connections, and with low CPU the limit is connections, not compute. RDS Proxy pools and reuses connections so that bursts reach the database as a manageable number. Read replicas cannot take writes, a higher max_connections risks memory, and Performance Insights diagnoses rather than fixes.

RDS Proxy pooling Lambda connections to an RDS database Many Lambda functions open connections to RDS Proxy. The proxy pools and reuses a smaller set of connections to the RDS for PostgreSQL DB instance. Lambda Lambda Lambda thousands at once RDS Proxy pools and reuses connections a few reused connections RDS for PostgreSQL same engine and size
Thousands of short Lambda connections land on the proxy, and the database sees a small pool it can handle.

Study

Keep practicing

Answer questions with a score at the end, or practice just this topic with the explanation after each one. No sign-up needed.

Take the free SOA-C03 practice examPractice RDS performance monitoringAll RDS performance monitoring questions

Want more on RDS performance monitoring? The 5 full-length practice sets have 6 more RDS performance monitoring questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets