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:

Deuterostomes

Lineage of bilateral animals in which the second opening on the embryo surface develops into a mouth; for example, echinoderms and chordates.

Radial Symmetry

A symmetrical arrangement in which body parts radiate out from a central point, common in animals like jellyfish and starfish.

Embryonic Opening

The embryonic opening refers to the blastopore, an early stage in the development of an embryo that can develop into the mouth or anus in different animal groups.

Chelicerates

A subgroup of arthropods that includes spiders, scorpions, ticks, and mites, characterized by the presence of chelicerae, which are claw-like mouthparts.