AWS Certified Solutions Architect – Professional (SAP-C02) — Question 229

A company runs an ecommerce application in a single AWS Region. The application uses a five-node Amazon Aurora MySQL DB cluster to store information about customers and their recent orders. The DB cluster experiences a large number of write transactions throughout the day.

The company needs to replicate the data in the Aurora database to another Region to meet disaster recovery requirements. The company has an RPO of 1 hour.

Which solution will meet these requirements with the LOWEST cost?

Answer options

• A. Modify the Aurora database to be an Aurora global database. Create a second Aurora database in another Region.
• B. Enable the Backtrack feature for the Aurora database. Create an AWS Lambda function that runs daily to copy the snapshots of the database to a backup Region.
• C. Use AWS Database Migration Service (AWS DMS). Create a DMS change data capture (CDC) task that replicates the ongoing changes from the Aurora database to an Amazon S3 bucket in another Region.
• D. Turn off automated Aurora backups. Configure Aurora backups with a backup frequency of 1 hour. Specify another Region as the destination Region. Select the Aurora database as the resource assignment.

Correct answer: C

Explanation

The correct answer is C because using AWS Database Migration Service (AWS DMS) with change data capture (CDC) allows for real-time replication of changes with minimal cost. Option A, while effective, involves higher costs due to the setup of a global database. Option B does not meet the RPO requirement since it relies on daily snapshots, and option D, turning off automated backups, is not a viable approach for maintaining disaster recovery.