Exam AWS Certified Database - Specialty topic 1 question 77 discussion

Sorry, I mean A. We cannot define full load or CDC in Replication instance

C&D unrelated A. "AWS DMS full load with ongoing change data capture (CDC)" (Note WITH means 1 task) B. allow both full load and ongoing change data capture (CDC) (note AND, means 2 tasks) There are two types of ongoing replication tasks: Full load plus CDC – The task migrates existing data and then updates the target database based on changes to the source database. CDC only – The task migrates ongoing changes after you have data on your target database. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Task.CDC.html https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.html

The answers are not very clearly stated, but A is the best option A suggests that the source instance needs to be configured for AWS DMS full load and data capture. There is some truth to that since binary logging (transaction logs) need to be enabled. xB suggest that it is the instance that is configured for full load and CDC, but it is really the task xC suggests that the task should be configured to generate full logs? xD configure two-way communication

whoever makes these questions is probably not sober - answer choice (A) is super apparent to the point of silliness - what ELSE would be the source? answer choice (B) says replication instance needs to be configured to allow Full Load + CDC. The INSTANCE doesnt do this. The Task it hosts does! Do they intend both to be the one and the same?

Ans A: Full load and CDC are defined in a DMS Tasks.

Question not clear. A seems more relevant.

"requires minimal downtime when the RDS DB instance goes live" in order to do CDC: "you must first ensure that ARCHIVELOG MODE is on to provide information to LogMiner. AWS DMS uses LogMiner to read information from the archive logs so that AWS DMS can capture changes" So my answer is A

https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle2postgresql.steps.configureoracle.html says "If you want to capture and apply changes (CDC), then you also need the following privileges." so A is the correct answer

This question is bit vague. I will go with A

A is the answer

B since Migrate existing data and replicate ongoing changes (full load + change data capture (CDC)) – To migrate data with minimal downtime, AWS DMS can migrate the existing data and replicate the data changes from the source to the target until the cutover. This migration type is best for small and medium databases that require minimal downtime, which only lasts for the duration of the cutover.

B i think... im not sure

A looks fine