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

Question

A company plans to use AWS Database Migration Service (AWS DMS) to migrate its database from one Amazon EC2 instance to another EC2 instance as a full load task. The company wants the database to be inactive during the migration. The company will use a dms.t3.medium instance to perform the migration and will use the default settings for the migration. Which solution will MOST improve the performance of the data migration?

Options

• AIncrease the number of tables that are loaded in parallel.
• BDrop all indexes on the source tables.
• CChange the processing mode from the batch optimized apply option to transactional mode.
• DEnable Multi-AZ on the target database while the full load task is in progress.

Explanation

For a full load task, we recommend that you drop primary key indexes, secondary indexes, referential integrity constraints, and data manipulation language (DML) triggers. Or you can delay their creation until after the full load tasks are complete. You don't need indexes during a full load task, and indexes incur maintenance overhead if they are present. Because the full load task loads groups of tables at a time, referential integrity constraints are violated. Similarly, insert, update, and delete triggers can cause errors, for example if a row insert is triggered for a previously bulk loaded table. Other types of triggers also affect performance due to added https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html

No community discussion yet for this question.