AWS Certified Database – Specialty — Question 254

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?

Answer options

• A. Use AWS Database Migration Service (AWS DMS) with ongoing replication in full LOB mode.
• B. Take a snapshot of the database. Create a new DB instance by using the snapshot.
• C. Use AWS Database Migration Service (AWS DMS) with ongoing replication in limited LOB mode.
• D. Use AWS Database Migration Service (AWS DMS) with ongoing replication in inline LOB mode.

Correct answer: D

Explanation

The correct answer is D because using AWS DMS with ongoing replication in inline LOB mode allows for the fastest data replication while ensuring that the ongoing changes to the original table are captured. Options A and C do not provide the same speed as inline replication, and option B does not support ongoing changes during the migration process.