AWS Certified Database – Specialty — Question 225

A company is planning to migrate a 40 TB Oracle database to an Amazon Aurora PostgreSQL DB cluster by using a single AWS Database Migration Service (AWS DMS) task within a single replication instance. During early testing, AWS DMS is not scaling to the company's needs. Full load and change data capture (CDC) are taking days to complete.

The source database server and the target DB cluster have enough network bandwidth and CPU bandwidth for the additional workload. The replication instance has enough resources to support the replication. A database specialist needs to improve database performance, reduce data migration time, and create multiple DMS tasks.

Which combination of changes will meet these requirements? (Choose two.)

Answer options

• A. Increase the value of the ParallelLoadThreads parameter in the DMS task settings for the tables.
• B. Use a smaller set of tables with each DMS task. Set the MaxFullLoadSubTasks parameter to a higher value.
• C. Use a smaller set of tables with each DMS task. Set the MaxFullLoadSubTasks parameter to a lower value.
• D. Use parallel load with different data boundaries for larger tables.
• E. Run the DMS tasks on a larger instance class. Increase local storage on the instance.

Correct answer: B

Explanation

The correct answer is B, as using a smaller set of tables with each DMS task and increasing the MaxFullLoadSubTasks parameter allows for more concurrent processing of data, thereby reducing migration time. Option A may help but does not directly address the need for multiple tasks, while options C and D do not optimize the task execution sufficiently. Option E, while useful for performance, does not focus on creating multiple tasks as required.