ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 328 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 328
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by marll88 at Nov. 26, 2023, 2:05 a.m.
Disclaimers:
  • - ExamTopics 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.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
marll88
Highly Voted 1 year, 5 months ago
I think D. Inline LOB mode – In inline LOB mode, you set the maximum LOB size that DMS transfers inline. LOBs smaller than the specified size are transferred inline. LOBs larger than the specified size are replicated using full LOB mode. You can select this option to replicate both small and large LOBs when most of the LOBs are small. DMS doesn’t support inline LOB mode for endpoints that don’t support Full LOB mode, like S3 and Redshift. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html
upvoted 5 times
...
MultiAZ
Most Recent 1 year, 3 months ago
Selected Answer: D
Answer is D. Set InlineLobMaxSize to 32KB to migrate the small documents fast.
upvoted 2 times
...
KikiNoviandi
1 year, 4 months ago
Selected Answer: D
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.
upvoted 3 times
...
silvaa360
1 year, 4 months ago
The fastest will always be LIMITED, but we loose data. Also, INLINE is only supported during full load (not CDC), so if the ongoing replication means only CDC can be an indicator to choose LIMITED.
upvoted 1 times
silvaa360
1 year, 4 months ago
Actually I'm chaning to inline. The question says all data, so cannot be limited. Also, as marll88 shows, when the most of the LOBs are small it makes sense to use INLINE.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago