Amazon Exam DBS-C01 Topic 2 Question 46 Discussion

Actual exam question for Amazon's DBS-C01 exam

Question #: 46
Topic #: 2

A corporation wishes to move a 1 TB Oracle database from its current location to an Amazon Aurora PostgreSQL DB cluster. The database specialist at the firm noticed that the Oracle database stores 100 GB of large binary objects (LOBs) across many tables. The Oracle database supports LOBs up to 500 MB in size and an average of 350 MB. AWS DMS was picked by the Database Specialist to transfer the data with the most replication instances.

How should the database specialist improve the transfer of the database to AWS DMS?

ACreate a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together

BCreate two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs

CCreate two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs

DCreate a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together

Show Suggested Answer

Suggested Answer: C

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPractices.LOBS,

'AWS DMS migrates LOB data in two phases: 1. AWS DMS creates a new row in the target table and populates the row with all data except the associated LOB value. 2.AWS DMS updates the row in the target table with the LOB data.' This means that we would need two tasks, one per phase and use limited LOB mode for best performance.

by Malinda at May 08, 2022, 03:21 PM

Limited Time Offer

25%

Off

Get Premium DBS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!