AWS Certified Database – Specialty — Question 183

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.)

Answer options

• A. Enable automatic backups on the source database
• B. Disable automatic backups on the source database
• C. Enable binary logging. Set the binlog format parameter to ROW on the source database.
• D. Enable binary logging. Set the binlog_format parameter to MIXED on the source database
• E. Use the source primary database as the source endpoint for the DMS task. Configure the task as full load plus change data capture(CDC) to complete the migration
• F. Use the source secondary database as the source endpoint for the DMS task. Configure the task as full load plus change data capture (CDC) to complete the migration

Correct answer: A, C, E

Explanation

Enabling automatic backups (Option A) on the source database ensures that data is protected during the migration process. Activating binary logging with the ROW format (Option C) is essential for capturing all changes accurately. Using the source primary database as the endpoint (Option E) allows for a complete data transfer and ongoing changes to be captured, which is vital for a successful migration. The other options either disable necessary backups, use the wrong binlog format, or incorrectly select the source endpoint.