AWS Certified DevOps Engineer – Professional (DOP-C02) — Question 349

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?

Answer options

• A. Turn on Performance Insights and DevOps Guru in the existing Aurora PostgreSQL DB cluster. Configure DevOps Guru to send notifications to the database team by using Amazon Simple Notification Service (Amazon SNS).
• B. Turn on Performance Insights in the existing Aurora PostrgreSQL DB cluster. Configure Amazon EventBridge to receive events from the existing Aurora PostgreSQL DB cluster. Configure the Aurora PostgreSQL DB cluster to send notifications to the database team by using Amazon Simple Notification Service (Amazon SNS).
• C. Turn on Performance Insights and DevOps Guru in the existing Aurora PostgreSQL DB cluster. Configure the Aurora PostgreSQL DB cluster to send notifications to the database team by using Amazon Simple Email Service (Amazon SES).
• D. Turn on Performance Insights in the existing Aurora PostrgreSQL DB cluster. Configure Amazon EventBridge to receive events from the existing Aurora PostgreSQL DB cluster. Configure DevOps Guru to send notifications to the database team by using Amazon Simple Notification Service (Amazon SNS).

Correct answer: A

Explanation

Enabling Performance Insights and Amazon DevOps Guru for RDS allows DevOps Guru to analyze performance telemetry and automatically detect anomalies like idle transactions blocking VACUUM operations. DevOps Guru then provides specific, actionable recommendations and can natively publish these alerts to an Amazon SNS topic for proactive notification. Other options are incorrect because they either rely on Amazon SES (which is not directly integrated with DevOps Guru for these notifications) or rely on EventBridge without enabling DevOps Guru on the DB cluster to analyze the Performance Insights data.