DOP-C02 Question 289
Select 2Your team is responsible for maintaining a critical application hosted on AWS. Recently, the application experienced intermittent downtime due to an unexpected issue with the database. To ensure faster resolution of future incidents, you want to implement an automated response mechanism that detects database-related anomalies and triggers a predefined remediation action, such as restarting the database. Which combination of services and configurations is the MOST appropriate for achieving this goal?
- A
Use Amazon CloudWatch to set up custom metrics and alarms to detect database anomalies, and configure an Amazon Simple Notification Service (SNS) topic to notify the team.
- B
Use AWS Lambda to create a function that restarts the database, and configure it as a target for an Amazon EventBridge rule triggered by a CloudWatch alarm.
- C
Enable Amazon RDS Performance Insights to automatically restart the database when performance issues are detected.
- D
Configure AWS Systems Manager Automation documents (SSM Documents) to execute predefined remediation actions and invoke them using EventBridge when anomalies are detected.
- E
Set up AWS Config to monitor database configuration changes and automatically restart the database when a non-compliant configuration is detected.
Show answer and explanation
Correct answers: B, D
Explanation
To implement an automated response mechanism for database anomalies, a combination of detection, orchestration, and remediation mechanisms is required. CloudWatch alarms can detect anomalies, Amazon EventBridge can route the events, and AWS Lambda or Systems Manager Automation documents can perform the remediation action (e.g., restarting the database). Options 2 and 4 provide the necessary components for this end-to-end solution.
- A. Incorrect.
While CloudWatch alarms and SNS notifications are useful for alerting the team about anomalies, they do not provide an automated remediation mechanism, such as restarting the database. Additional integration is required to automate the response.
- B. Correct.
Using AWS Lambda to restart the database is a valid approach. When combined with an EventBridge rule triggered by a CloudWatch alarm, it enables automated detection and remediation of database anomalies.
- C. Incorrect.
Amazon RDS Performance Insights is a monitoring tool that provides performance metrics and diagnostics, but it does not have the capability to automatically restart the database in response to issues.
- D. Correct.
AWS Systems Manager Automation documents (SSM Documents) allow you to define and execute automated remediation actions. By invoking these documents through EventBridge when anomalies are detected, you can implement a robust automated response mechanism.
- E. Incorrect.
AWS Config is primarily used for monitoring resource compliance and configuration changes. While it can detect non-compliant configurations, it is not designed for real-time anomaly detection and automated remediation of database issues.