Discover the most cost-effective solution to meet disaster recovery requirements for an Amazon Aurora MySQL database with a 1-hour Recovery Point Objective (RPO). Learn how AWS Database Migration Service (DMS) and change data capture (CDC) can continuously replicate data changes to an Amazon S3 bucket in another Region, ensuring data durability and cost-efficiency.
Table of Contents
Question
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?
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.
Answer
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.
Explanation
- AWS DMS is a cloud service that enables efficient and secure data migration and replication between various data sources and targets, including databases, Amazon S3, and more.
- The change data capture (CDC) feature in AWS DMS allows for continuous replication of data changes from a source database to a target location.
- By setting up a CDC task with AWS DMS, the company can continuously replicate the changes made to the Aurora database in the primary Region to an S3 bucket in the target Region.
- Storing the replicated data in an S3 bucket provides durability and cost-effectiveness, as S3 is generally less expensive than running a secondary database instance.
- With CDC, the data in the target S3 bucket will remain in sync with the primary Aurora database, ensuring that the RPO of 1 hour is met.
- This solution eliminates the need for additional database instances, backups, or manual snapshot copying, thereby minimizing the overall cost compared to the other options.
Other options and their limitations:
Option A (Aurora Global Database) is a more expensive solution as it requires running a secondary database instance in the target Region. Option B (Backtrack and AWS Lambda) involves daily snapshot copying, which may not meet the RPO of 1 hour and could incur additional costs for Lambda execution and snapshot storage. Option D (Frequent Aurora Backups) can be more expensive due to the cost of storing frequent backups, and it may not provide continuous replication to meet the RPO requirement.
Amazon AWS Certified Solutions Architect – Professional SAP-C02 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Professional SAP-C02 exam and earn Amazon AWS Certified Solutions Architect – Professional SAP-C02 certification.