nerdexam
Amazon

DBS-C01 · Question #288

A company's database specialist is migrating a production Amazon RDS for MySQL database to Amazon Aurora MySQL. The source database is configured for Multi-AZ. The company's production team wants to v

The correct answer is A. Enable automatic backups on the source database C. Enable binary logging. Set the binlog format parameter to ROW on the source database. E. Use the source primary database as the source endpoint for the DMS task. Configure the task as. To migrate a production Amazon RDS for MySQL Multi-AZ database to Amazon Aurora MySQL using AWS DMS for validation before cutover, enable automatic backups, set binary logging to ROW format, and use the primary database as the DMS source endpoint.

Submitted by yasin.bd· Mar 6, 2026Deployment and Migration

Question

A company's database specialist is migrating a production Amazon RDS for MySQL database to Amazon Aurora MySQL. The source database is configured for Multi-AZ. The company's production team wants to validate the target database before switching the associated application over to use the new database endpoint. The database specialist plans to use AWS Database Migration Service (AWS DMS) for the migration. Which steps should the database specialist perform to meet the production team's requirement? (Choose three.)

Options

  • AEnable automatic backups on the source database
  • BDisable automatic backups on the source database
  • CEnable binary logging. Set the binlog format parameter to ROW on the source database.
  • DEnable binary logging. Set the binlog_format parameter to MIXED on the source database
  • EUse the source primary database as the source endpoint for the DMS task. Configure the task as
  • FUse the source secondary database as the source endpoint for the DMS task. Configure the task

How the community answered

(33 responses)
  • A
    64% (21)
  • B
    9% (3)
  • D
    21% (7)
  • F
    6% (2)

Why each option

To migrate a production Amazon RDS for MySQL Multi-AZ database to Amazon Aurora MySQL using AWS DMS for validation before cutover, enable automatic backups, set binary logging to ROW format, and use the primary database as the DMS source endpoint.

AEnable automatic backups on the source databaseCorrect

Enabling automatic backups on the source RDS database is a critical best practice to ensure data recovery and safety during any migration process, even though it doesn't directly enable DMS.

BDisable automatic backups on the source database

Disabling automatic backups on a production database before or during a migration is a poor practice that increases the risk of data loss.

CEnable binary logging. Set the binlog format parameter to ROW on the source database.Correct

AWS DMS requires binary logging to be enabled on the MySQL source database to capture change data for continuous replication, and setting the `binlog_format` parameter to `ROW` is generally recommended for data consistency and integrity during replication tasks.

DEnable binary logging. Set the binlog_format parameter to MIXED on the source database

While binary logging is essential, setting the `binlog_format` to `ROW` (as in option C) is generally the preferred and more robust choice for AWS DMS replication tasks to ensure data accuracy compared to `MIXED`.

EUse the source primary database as the source endpoint for the DMS task. Configure the task asCorrect

When using AWS DMS with an Amazon RDS Multi-AZ source, the DMS task must use the primary database instance as its source endpoint to capture all writes and replicate them to the target.

FUse the source secondary database as the source endpoint for the DMS task. Configure the task

AWS DMS tasks are configured to connect to the primary instance of an RDS Multi-AZ deployment to capture changes, not the secondary (standby) instance.

Concept tested: AWS DMS prerequisites for homogeneous MySQL migration

Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html

Topics

#RDS MySQL to Aurora MySQL#AWS DMS#change data capture (CDC)#binary logging

Community Discussion

No community discussion yet for this question.

Full DBS-C01 Practice