AWS Certified Database – Specialty — Question 50

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?

Answer options

• 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

Correct answer: B

Explanation

The correct answer is B because it allows for optimal handling of LOBs by using full LOB mode for the LOB tables, ensuring they are migrated efficiently without size limitations. Option A would not separate the LOBs, which could lead to performance issues, while options C and D use limited LOB mode, which may restrict the size and cause complications with larger LOBs.