nerdexam
Amazon

SAP-C02 · Question #181

A retail company has a small ecommerce web application that uses an Amazon RDS for PostgreSQL DB instance. The DB instance is deployed with the Multi-AZ option turned on. Application usage recently…

The correct answer is B. Turn on Enhanced Monitoring and Performance Insights for the DB instance. The cause of the issue is not known (i.e. it might not be slow queries) and RDS has SQL statistics in Performance Insight to investigate. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/sql-statistics.html…

Submitted by chen.hong· Mar 6, 2026Continuous Improvement for Existing Solutions

Question

A retail company has a small ecommerce web application that uses an Amazon RDS for PostgreSQL DB instance. The DB instance is deployed with the Multi-AZ option turned on. Application usage recently increased exponentially and users experienced frequent http 503 errors. Users reported the errors, and the company's reputation suffered. The company could not identify a definitive root cause. The company wants to improve its operational readiness and receive alerts before users notice an incident. The company also wants to collect enough information to determine the root cause of any future incident. Which solution will meet these requirements with the LEAST operational overhead?

Options

  • ATurn on Enhanced Monitoring for the DB instance
  • BTurn on Enhanced Monitoring and Performance Insights for the DB instance
  • CTurn on log exports to Amazon CloudWatch for the PostgreSQL logs on the DB instance
  • DTurn on Performance Insights for the DB instance

How the community answered

(40 responses)
  • A
    15% (6)
  • B
    75% (30)
  • C
    8% (3)
  • D
    3% (1)

Explanation

The cause of the issue is not known (i.e. it might not be slow queries) and RDS has SQL statistics in Performance Insight to investigate. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/sql-statistics.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Cloudwatch.ht https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights_Counters.html

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full SAP-C02 Practice