AWS Certified Database – Specialty — Question 56

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?

Answer options

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

Correct answer: D

Explanation

The correct answer is D because enabling Amazon RDS Performance Insights allows for real-time monitoring and visualization of database performance, helping to identify problematic queries correlated with the slow response times. Options A and B provide monitoring solutions but are less efficient and do not specifically target query performance. Option C focuses solely on locking queries, which may not encompass all potential causes of the slowdown.