AWS Certified Database – Specialty — Question 64

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?

Answer options

• 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)

Correct answer: A

Explanation

The correct answer is A because configuring the on-premises application database as a source for an AWS DMS full load with ongoing change data capture (CDC) ensures that the migration can accommodate changes made during the process, minimizing downtime. Options B, C, and D do not directly address the need for the on-premises database to act as the source of data with CDC, which is crucial for this migration scenario.