How should the Data...
 
Notifications
Clear all

How should the Database Specialist optimize the database migration using AWS DMS?

1 Posts
1 Users
0 Likes
51 Views
Morgan
(@pacapacmorgan)
Noble Member
Joined: 7 months ago
Posts: 390
Topic starter  

A company is looking to migrate a 1 TB Oracle database from on-premises to an Amazon Aurora PostgreSQL DB cluster. The company’s Database Specialist discovered that the Oracle database is storing 100 GB of large binary objects (LOBs) across multiple tables. The Oracle database has a maximum LOB size of 500 MB with an average LOB size of 350 MB. The Database Specialist has chosen AWS DMS to migrate the data with the largest replication instances.

How should the Database Specialist optimize the database migration using AWS DMS?

  • A . Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together
  • B . Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs
  • C . Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs
  • D . Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together

Show Answer Hide Answer

Suggested Answer: C

   
Quote
Share: