nerdexam
Amazon

SAP-C02 · Question #565

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 cl

The correct answer is C. Use AWS Database Migration Service (AWS DMS). Create a DMS change data capture (CDC). The company needs to replicate a highly active Aurora MySQL database to another AWS Region for disaster recovery with a 1-hour RPO at the lowest cost.

Submitted by zhang_li· Mar 6, 2026Continuous Improvement for Existing Solutions

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?

Options

  • AModify the Aurora database to be an Aurora global database. Create a second Aurora database
  • BEnable the Backtrack feature for the Aurora database. Create an AWS Lambda function that runs
  • CUse AWS Database Migration Service (AWS DMS). Create a DMS change data capture (CDC)
  • DTurn off automated Aurora backups. Configure Aurora backups with a backup frequency of 1

How the community answered

(38 responses)
  • A
    5% (2)
  • B
    11% (4)
  • C
    63% (24)
  • D
    21% (8)

Why each option

The company needs to replicate a highly active Aurora MySQL database to another AWS Region for disaster recovery with a 1-hour RPO at the lowest cost.

AModify the Aurora database to be an Aurora global database. Create a second Aurora database

An Aurora global database provides an RPO of typically less than 1 second, which is much lower than the 1-hour requirement, and would be a higher-cost solution due to its advanced synchronous-like replication capabilities.

BEnable the Backtrack feature for the Aurora database. Create an AWS Lambda function that runs

Aurora Backtrack allows you to rewind the DB cluster to a specific time, but it operates within a single AWS Region and does not provide cross-Region disaster recovery capabilities.

CUse AWS Database Migration Service (AWS DMS). Create a DMS change data capture (CDC)Correct

AWS DMS with a change data capture (CDC) task can continuously replicate data changes from the source Aurora MySQL database to a target database in another region. This approach meets the RPO requirement and offers a cost-effective solution for cross-region data synchronization compared to dedicated global database setups for a 1-hour RPO.

DTurn off automated Aurora backups. Configure Aurora backups with a backup frequency of 1

Disabling automated backups and configuring manual backups does not provide continuous cross-Region replication and would significantly increase the RPO, failing to meet the disaster recovery requirements.

Concept tested: Cross-Region Data Replication for DR

Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Task.CDC.html

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full SAP-C02 Practice