Examice

Exam SAP-C01 All QuestionsBrowse all questions from this exam

Question 908

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?

Turn on Enhanced Monitoring for the DB instance. Modify the corresponding parameter group to turn on query logging for all the slow queries. Create Amazon CloudWatch alarms. Set the alarms to appropriate thresholds that are based on performance metrics in CloudWatch.

Turn on Enhanced Monitoring and Performance Insights for the DB instance. Create Amazon CloudWatch alarms. Set the alarms to appropriate thresholds that are based on performance metrics in CloudWatch.

Turn on log exports to Amazon CloudWatch for the PostgreSQL logs on the DB instance. Analyze the logs by using Amazon Elasticsearch Service (Amazon ES) and Kibana. Create a dashboard in Kibana. Configure alerts that are based on the metrics that are collected.

Turn on Performance Insights for the DB instance. Modify the corresponding parameter group to turn on query logging for all the slow queries. Create Amazon CloudWatch alarms. Set the alarms to appropriate thresholds that are based on performance metrics in CloudWatch.

Correct Answer: B

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.

Discussion

caleOption: B

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

cale

Additional reference to support: (1) https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Cloudwatch.html and (2) https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights_Counters.html.

AwsBRFanOption: D

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

sb333

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.

JohnPi

Performance Insights automatically publishes metrics to Amazon CloudWatch

kaparaOption: D

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.

mrgreatness

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/

Sathish1412

Option D

28hangcanOption: A

A is the correct Answer

Blair77Option: B

-"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

Guoxian

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

ArreRaja

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

Biden

Perf Insights supported for Postgre; https://aws.amazon.com/rds/performance-insights/. Hence D

ArreRaja

my bad. Perf insight is supported for RDS Postgres

WhyIronManOption: B

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...

evargasbrzOption: B

I'll go with B

aqiao

Why A is wrong?

aqiao

Got it, Enhanced log is for collecting and analyzing OS level metrics, such as CPU,memory, which can't get SQL running information

ToanVN1988Option: D

Need to combine monitor and logging analytics. D is correct

joancarlesOption: B

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

psou7

i would go with D

skywalkerOption: B

B is my choice.