DBS-C01 · Question #337
A database specialist needs to move a table from a database that is running on an Amazon Aurora PostgreSQL DB cluster into a new and distinct database cluster. The new table in the new database must b
The correct answer is D. Use AWS Database Migration Service (AWS DMS) with ongoing replication in inline LOB mode.. Full LOB Mode - Full LOB mode can be quite slow, Limited LOB Mode- LOBs that exceed the maximum LOB size are truncated, and a warning is issued to the log file Inline LOB mode - LOBs larger than the specified size are replicated using full LOB mode.
Question
A database specialist needs to move a table from a database that is running on an Amazon Aurora PostgreSQL DB cluster into a new and distinct database cluster. The new table in the new database must be updated with any changes to the original table that happen while the migration is in progress. The original table contains a column to store data as large as 2 GB in the form of large binary objects (LOBs). A few records are large in size, but most of the LOB data is smaller than 32 KB. What is the FASTEST way to replicate all the data from the original table?
Options
- AUse AWS Database Migration Service (AWS DMS) with ongoing replication in full LOB mode.
- BTake a snapshot of the database. Create a new DB instance by using the snapshot.
- CUse AWS Database Migration Service (AWS DMS) with ongoing replication in limited LOB mode.
- DUse AWS Database Migration Service (AWS DMS) with ongoing replication in inline LOB mode.
How the community answered
(53 responses)- A2% (1)
- B6% (3)
- C11% (6)
- D81% (43)
Explanation
Full LOB Mode - Full LOB mode can be quite slow, Limited LOB Mode- LOBs that exceed the maximum LOB size are truncated, and a warning is issued to the log file Inline LOB mode - LOBs larger than the specified size are replicated using full LOB mode.
Topics
Community Discussion
No community discussion yet for this question.