Q46 — AWS DOP-C02 Ch.2

Question 46 of 100 | ← Chapter 2

A company is using AWS Database Migration Service (AWS DMS) to replicate data from an on-premises source database to a target Amazon Aurora PostgreSQL database. The company created a DMS replication task with change data capture (CDC). Replication experiences unplanned interruptions that impact critical functionality. The company wants to improve replication resilience and receive notifications about such interruptions. Which solution meets these requirements with the least operational overhead?

• A. Use AWS DataSync to copy data from the source database to Amazon S3. Configure an AWS Lambda function to copy data from S3 to the target database. Configure Amazon CloudWatch alarms to monitor Lambda errors and throttling. Use an Amazon Simple Notification Service (Amazon SNS) topic for email notifications.
• B. Create Amazon CloudWatch alarms to monitor DMS replication task metrics and host metrics. Use an Amazon Simple Notification Service (Amazon SNS) topic for email notifications and invoke an AWS Lambda function to provision a standby DMS replication instance in a different AWS Region.
• C. Create Amazon CloudWatch alarms to monitor DMS replication task metrics and host metrics. Use an Amazon Simple Notification Service (Amazon SNS) topic for email notifications. After receiving notification, configure a new DMS replication task in the same AWS Region.
• D. Modify the DMS replication instance to enable Multi-AZ support. Create Amazon CloudWatch alarms to monitor DMS replication task metrics and host metrics. Use an Amazon Simple Notification Service (Amazon SNS) topic for email notifications. ✓

Correct Answer: D. Modify the DMS replication instance to enable Multi-AZ support. Create Amazon CloudWatch alarms to monitor DMS replication task metrics and host metrics. Use an Amazon Simple Notification Service (Amazon SNS) topic for email notifications.

Explanation

Option D is optimal. Enabling Multi-AZ support for the DMS replication instance improves resilience and reduces interruption risk. CloudWatch alarms monitoring replication task and host metrics provide timely anomaly detection. Using Amazon SNS for email notifications ensures prompt awareness—all with minimal operational overhead. Option A adds complexity and cost via DataSync and Lambda. Option B incurs higher overhead by provisioning standby instances across Regions. Option C requires manual intervention and lacks the proactive resilience of Multi-AZ.