A Company Just Migrated to Amazon Aurora PostgreSQL from an On-Premises

question 26

Multiple Choice

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.

---

Definitions:

Skinner

B.F. Skinner, an American psychologist known for his work in behaviorism and for developing the theory of operant conditioning.

Pigeons

Birds that are often found in urban areas, known for their ability to find their way home over long distances, used in research for studying navigation and behavior.

Critical Thinking

Analytical thinking aimed at assessing the validity of information to make logical conclusions.

Reinforcement

In psychology, a process in which a behavior is strengthened or increased by the consequences that follow.