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:

Puberty

The developmental stage during which a person undergoes physical changes leading to sexual maturity.

Homosexuality

A sexual orientation characterized by a romantic or sexual attraction to individuals of the same gender.

X Chromosome

One of the two sex chromosomes, determining genetic sex when paired with another X chromosome (female) or a Y chromosome (male).

Hypothalamus

A region of the brain responsible for hormone production that regulates essential bodily functions, including temperature, hunger, thirst, and emotional activity.