DBS-C01 · Question #92
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
The correct answer is C. Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPracti "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 t
Question
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?
Options
- ACreate a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data
- BCreate two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB
- CCreate two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of
- DCreate a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate
How the community answered
(33 responses)- A6% (2)
- B15% (5)
- C58% (19)
- D21% (7)
Explanation
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPracti "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.
Topics
Community Discussion
No community discussion yet for this question.