What change should the Database Specialist make to enable the migration?

A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB instance goes live.

What change should the Database Specialist make to enable the migration?
A . Configure the on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)
B . Configure the AWS DMS replication instance to allow both full load and ongoing change data capture (CDC)
C . Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)
D . Configure the AWS DMS connections to allow two-way communication to allow for ongoing change data capture (CDC)

View Answer

Answer: A

Explanation:

"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" https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle2postgresql.steps.configureoracle.html "If you want to capture and apply changes (CDC), then you also need the following privileges."