CV0-004 Deployment Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✓

  Azure Database Migration Service (DMS)

  Why this is correct

  Azure Database Migration Service performs online migrations, continuously replicating ongoing transactions from the source SQL Server to Azure SQL Database until cutover. This satisfies the minimal-downtime constraint, since the source stays operational and readable throughout. Offline approaches such as backup-and-restore or BACPAC export would require pausing writes for the full 10 TB transfer.

• ✗

  Azure Data Sync

  Why it's wrong here

  Azure Data Sync synchronises data between databases via sync groups and cannot perform the schema and object-level migration into Azure SQL Database. It is tempting for keeping two live databases aligned, but here the requirement is a one-time migration with minimal downtime, which Data Migration Service handles.

• ✗

  Azure Import/Export Service

  Why it's wrong here

  Azure Import/Export likewise moves data via shipped drives, requiring the database to be quiesced for export and offering no continuous replication of ongoing changes. It fits offline bulk seeding of cold data, not a scenario demanding minimal downtime with the source database kept operational throughout.

• ✗

  Azure Data Box

  Why it's wrong here

  Azure Data Box ships physical disks, so the source database must be taken offline for a consistent snapshot and any changes made during transit need separate catch-up. It suits one-off bulk transfers of many terabytes where downtime is acceptable, not a live 10 TB database requiring minimal downtime.

Go deeper

Related to this question