DOP-C02 Question #382: Real Exam Question with Answer & Explanation

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

Explanation

Amazon DevOps Guru provides proactive recommendations for database performance issues, including identifying long-running idle transactions that can block queries and prevent VACUUM operations. Enabling Performance Insights for Amazon Aurora PostgreSQL allows monitoring query execution and performance metrics. By configuring DevOps Guru to send notifications via Amazon SNS, the database team can receive alerts and recommended actions in real time, allowing them to proactively address potential issues before they affect performance.

No community discussion yet for this question.