nerdexam
Amazon

DOP-C02 · Question #382

A company uses an Amazon Aurora PostgreSQL DB cluster and loads transactional data into the database every 5 hours. Data analysts use the Aurora PostgreSQL database to run short-running queries, creat

Sign in or unlock DOP-C02 to reveal the answer and full explanation for question #382. The question stem and answer options stay visible for context.

Submitted by packet_pusher· Mar 6, 2026Monitoring and Logging

Question

A company uses an Amazon Aurora PostgreSQL DB cluster and loads transactional data into the database every 5 hours. Data analysts use the Aurora PostgreSQL database to run short-running queries, create complex aggregated queries, and create simple reports that use the data. The data analysts also manually update the data, including deleting and inserting data. The data analysts have reported performance issues. The database team recently identified a long-running idle transaction connection that affected performance by blocking other queries and preventing VACUUM operations. The team wants to be proactively notified about these potential operational issues and about the recommended actions to fix the issues. The company's AWS account uses Amazon DevOps Guru to monitor all the applications in the account. Which solution will meet these requirements?

Options

  • ATurn on Performance Insights and DevOps Guru in the existing Aurora PostgreSQL DB cluster.
  • BTurn on Performance Insights in the existing Aurora PostrgreSQL DB cluster. Configure Amazon
  • CTurn on Performance Insights and DevOps Guru in the existing Aurora PostgreSQL DB cluster.
  • DTurn on Performance Insights in the existing Aurora PostrgreSQL DB cluster. Configure Amazon

Unlock DOP-C02 to see the answer

You've previewed enough free DOP-C02 questions. Unlock DOP-C02 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.

Topics

#Aurora PostgreSQL#Performance Insights#DevOps Guru#database monitoring
Full DOP-C02 Practice