ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam
Go to Exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 908 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional
Question #: 908
Topic #: 1
[All AWS Certified Solutions Architect - Professional Questions]

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?

  • A. 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.
  • B. 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.
  • C. 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.
  • D. 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by cale at Sept. 7, 2022, 2:13 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
cale
Highly Voted 2 years, 8 months ago
Selected Answer: 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
upvoted 16 times
cale
2 years, 8 months ago
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.
upvoted 1 times
...
...
AwsBRFan
Highly Voted 2 years, 8 months ago
Selected Answer: 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
upvoted 5 times
...
WhyIronMan
Most Recent 9 months, 4 weeks ago
Selected Answer: 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...
upvoted 1 times
...
evargasbrz
2 years, 4 months ago
Selected Answer: B
I'll go with B
upvoted 1 times
...
mrgreatness
2 years, 5 months ago
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/
upvoted 3 times
...
28hangcan
2 years, 6 months ago
Selected Answer: A
A is the correct Answer
upvoted 2 times
...
aqiao
2 years, 6 months ago
Why A is wrong?
upvoted 1 times
devilman222
8 months, 3 weeks ago
Because its marketed as the correct answer which is usually wrong also wrong as OS information won't help with sql errors.
upvoted 1 times
...
aqiao
2 years, 6 months ago
Got it, Enhanced log is for collecting and analyzing OS level metrics, such as CPU,memory, which can't get SQL running information
upvoted 1 times
...
...
ToanVN1988
2 years, 6 months ago
Selected Answer: D
Need to combine monitor and logging analytics. D is correct
upvoted 1 times
...
Blair77
2 years, 6 months ago
Selected Answer: 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
upvoted 2 times
...
joancarles
2 years, 6 months ago
Selected Answer: 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
upvoted 1 times
...
psou7
2 years, 6 months ago
i would go with D
upvoted 1 times
...
skywalker
2 years, 7 months ago
Selected Answer: B
B is my choice.
upvoted 1 times
...
sb333
2 years, 7 months ago
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.
upvoted 4 times
JohnPi
2 years, 7 months ago
Performance Insights automatically publishes metrics to Amazon CloudWatch
upvoted 1 times
...
...
kapara
2 years, 7 months ago
Selected Answer: 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.
upvoted 4 times
...
Sathish1412
2 years, 8 months ago
Option D
upvoted 3 times
...
Guoxian
2 years, 8 months ago
I would vote for D since it could be both. D covers both Postgres DB performance and slow query.
upvoted 2 times
...
ArreRaja
2 years, 8 months ago
cannot be D as Performance insight is not supported for RDS PostgresSQL. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Enabling.html
upvoted 2 times
Biden
2 years, 8 months ago
Perf Insights supported for Postgre; https://aws.amazon.com/rds/performance-insights/. Hence D
upvoted 1 times
...
ArreRaja
2 years, 7 months ago
my bad. Perf insight is supported for RDS Postgres
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago