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?

Topic #: - All AWS Certified Database - Specialty Questions

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.

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Share this post

Join the Discussion