DBS-C01 Question #288: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

• B. Disabling automatic backups on a production database before or during a migration is a poor practice that increases the risk of data loss.
• D. 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.
• F. 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

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

No community discussion yet for this question.