SAP-C01 Exam - Question 908

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?

Examice · Accepted Answer

Turning on both Enhanced Monitoring and Performance Insights for the DB instance will provide comprehensive monitoring and diagnostic capabilities. Enhanced Monitoring provides real-time operational data, which can be used to set up CloudWatch alarms. Performance Insights offers deep insights into the database performance and can help identify issues like slow queries or resource bottlenecks. This combination ensures that detailed metrics and diagnostic information are readily available while keeping operational overhead low, as it leverages built-in AWS services without requiring extensive manual configuration.

cale · Answer

I think it is B because 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 re: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/sql-statistics.html

AwsBRFan · Answer

Yeap really in doubt about A and D.
1- Yes, performance insight support RDS PostgresSQL:
https://aws.amazon.com/rds/performance-insights/
2- Performance insight will help on RCA

kapara · Answer

D. Performance Insights will publish fewer metrics and will be less complex to set alarm policy too. since this question seems to blame the DB performance as the source for the issue, the Performance Insights metrics should be the metrics we need.

sb333 · Answer

The answer is B - to enable both Enhanced Monitoring and Performance Insights. Enhanced Monitoring produces CloudWatch metrics, which can be the basis for CloudWatch alarms. Performance Insights is a great tool for troubleshooting, but it is a dashboard that does not allow data to be exported (to CloudWatch or otherwise).

The answer cannot be D, because neither Performance Insights nor query logging (stored locally on DB server) can be enabled for CloudWatch alarms.

Sathish1412 · Answer

Option D

mrgreatness · Answer

B for me: https://aws.amazon.com/blogs/database/monitor-amazon-rds-for-postgresql-and-amazon-aurora-for-postgresql-database-log-errors-and-set-up-notifications-using-amazon-cloudwatch/

ArreRaja · Answer

cannot be D as Performance insight is not supported for RDS PostgresSQL. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Enabling.html

Guoxian · Answer

I would vote for D since it could be both. D covers both Postgres DB performance and slow query.

Blair77 · Answer

-"The company also wants to collect enough information to determine the root cause of any future incident." Enhanced Monitoring plus Performance Insights will provide that... Go with BBB
https://www.youtube.com/watch?v=iTDt4ZhD25U

28hangcan · Answer

A is the correct Answer

skywalker · Answer

B is my choice.

psou7 · Answer

i would go with D

joancarles · Answer

I think it's B because the way to determine the root problem is to enable multiple mechanisms. Enhanced Monitoring, Performance Insights and metrics in CloudWatch:
https://aws.amazon.com/premiumsupport/knowledge-center/rds-aurora-postgresql-performance-issues/?nc1=h_ls

ToanVN1988 · Answer

Need to combine monitor and logging analytics. D is correct

aqiao · Answer

Why A is wrong?

evargasbrz · Answer

I'll go with B

WhyIronMan · Answer

B)

Enhanced Monitoring plus Performance Insights will provide that +
with the LEAST operational overhead
and changing the parameter group can cause the RDS do enter in modifying state making it unavailable... and we are in production...

SAP-C01 Exam - Question 908

Discussion