A Database Specialist Is Migrating an On-Premises Microsoft SQL Server

question 82

Multiple Choice

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)

---

Definitions:

Unamortized Premium

The portion of a bond premium that has not yet been amortized or gradually written off as an expense over the bond's life.

Redeemed

The act of repurchasing or paying off a security such as a bond or preferred stock at its maturity or before.

Loss On Redemption

The financial loss experienced when a debt security is redeemed before its maturity date for more than its par value.

Carrying Value

The book value of an asset on a company’s balance sheet, calculated as the original cost minus accumulated depreciation.