DBS-C01 · Question #26
DBS-C01 Question #26: Real Exam Question with Answer & Explanation
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.
Question
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?
Options
- ACreate an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and
- BLaunch an Amazon EC2 instance, and install and configure an open-source PostgreSQL
- CModify the logging database parameter to log all the queries related to locking in the database
- DEnable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.