Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 69 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 69
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database. After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower. The company has narrowed down the cause of this issue to the database and not the application.
Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?

A. Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption. Watch these dashboards during the next slow period.
B. Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs.
C. Modify the logging database parameter to log all the queries related to locking in the database and then check the logs after the next slow period for this information.
D. Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.

Show Suggested Answer

Suggested Answer: D 🗳️

by BillyC at July 27, 2020, 2:37 p.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

Submit Cancel

Pranava_GCP

1 year, 8 months ago

Selected Answer: D

D. Enable Amazon RDS Performance Insights "Whether your database performance problem is due to database configuration or application design issues, you can quickly identify the bottleneck and see which SQL statements are contributing to it." https://aws.amazon.com/rds/performance-insights/

upvoted 2 times

...

novice_expert

3 years, 1 month ago

Selected Answer: D

RDS Performance Insights -> identify any queries that are related to spikes in the graph during the next slow period.

upvoted 3 times

...

tugboat

3 years, 3 months ago

Selected Answer: D

Performance Insights

upvoted 2 times

...

sj143

3 years, 4 months ago

if the database is transitioned to Aurora postgresSQL - how will enabling Amazon RDS performance insight help?

upvoted 1 times

VPup

3 years, 4 months ago

D - https://aws.amazon.com/about-aws/whats-new/2021/10/rds-performance-insights-more-regions/ " Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS and Aurora that helps you quickly assess the load on your database and determine when and where to take action."

upvoted 4 times

...

guru_ji

3 years, 7 months ago

Answer: D

upvoted 2 times

...

myutran

3 years, 7 months ago

Ans: D

upvoted 1 times

...

Ashoks

3 years, 7 months ago

D is ..

upvoted 2 times

...

BillyMadison

3 years, 7 months ago

https://aws.amazon.com/blogs/database/optimizing-and-tuning-queries-in-amazon-rds-postgresql-based-on-native-and-external-tools/ You can monitor SQL queries that caused load, I/O waits, and the users and hosts through which the queries ran. As you can see in the previous screenshot, the same SQL query has been reported as consuming the most CPUs. Performance Insights supports counter metrics for RDS PostgreSQL. Counter metrics allow you to customize your Performance Insights dashboard to include up to 10 additional graphs from the available operating system and database metrics. It is helpful to identify and analyze performance issues by correlating load charts. Performance counter metrics are native and non-native. As you can see in the following screenshot, counter metrics are updated with tuples fetched, tuples returned, blocks latency, and blocks read.

upvoted 4 times

...

BillyMadison

3 years, 7 months ago

Going with D for now because of https://aws.amazon.com/blogs/database/optimizing-and-tuning-queries-in-amazon-rds-postgresql-based-on-native-and-external-tools/ "AWS recently released a feature called Amazon RDS Performance Insights, which provides an easy-to-understand dashboard for detecting performance problems in terms of load." "AWS recently released a feature called Amazon RDS Performance Insights, which provides an easy-to-understand dashboard for detecting performance problems in terms of load." The other possible answers are B & C but those solutions include the possibility it is an application issue which the question says it is not.

upvoted 3 times

...

BillyC

3 years, 8 months ago

Ans D is correct

upvoted 2 times

...