CompTIA Cloud+ (CV0-004)DeploymentHard
A company is planning to migrate a large relational database (20TB) from an on-premises data center to a public cloud provider. The database needs to remain online during the migration with minimal performance impact on the source system. After the initial full data transfer, a continuous synchronization mechanism is required to capture ongoing changes until the cutover. Which migration strategy is most appropriate?
- AManual data export/import
- BOffline Migration
- CDatabase Migration Service (DMS) with Change Data Capture (CDC)
- DLift-and-shift with snapshot replication
Show answer & explanationAnswer & explanation
Correct answer: C. Database Migration Service (DMS) with Change Data Capture (CDC)
A Database Migration Service (DMS) combined with Change Data Capture (CDC) is designed for large-scale, online database migrations. It performs an initial bulk load and then continuously replicates ongoing changes from the source to the target, ensuring minimal downtime and preserving data consistency until cutover.
Why the other options are wrong
- A. Manual export/import is prone to errors, requires significant downtime, and is not feasible for a 20TB online database.
- B. Offline migration requires significant downtime, which is not acceptable for an online database.
- D. Snapshot replication is generally not suitable for continuous, real-time synchronization of an active database with minimal impact.
Database Migration Service (DMS) with CDC
A cloud service that enables continuous migration of databases to the cloud, using Change Data Capture (CDC) for ongoing synchronization.
- Supports homogeneous and heterogeneous migrations.
- Minimizes downtime for critical databases.
- Automatically captures and applies changes from source to target.
Memory trick: DMS + CDC: Data moves continuously.