nerdexam
CompTIA

CV0-003 · Question #882

A cloud engineer needs to perform a database migration. The database has a restricted SLA and cannot be offline for more than ten minutes per month. The database stores 800GB of data, and the network

The correct answer is B. Create a replica database synchronize the data, and switch to the new instance.. With only 10 minutes of allowable downtime per month and 800 GB of data over a 100 MBps link, a full offline transfer would take over two hours - making a live replication and cutover approach the only viable option.

Cloud Architecture and Design

Question

A cloud engineer needs to perform a database migration. The database has a restricted SLA and cannot be offline for more than ten minutes per month. The database stores 800GB of data, and the network bandwidth to the CSP is 100MBps. Which of the following is the best option to perform the migration?

Options

  • ACopy the database to an external device and ship the device to the CSP
  • BCreate a replica database synchronize the data, and switch to the new instance.
  • CUtilize a third-party tool to back up and restore the data to the new database
  • DUse the database import/export method and copy the exported file.

How the community answered

(46 responses)
  • A
    13% (6)
  • B
    61% (28)
  • C
    4% (2)
  • D
    22% (10)

Why each option

With only 10 minutes of allowable downtime per month and 800 GB of data over a 100 MBps link, a full offline transfer would take over two hours - making a live replication and cutover approach the only viable option.

ACopy the database to an external device and ship the device to the CSP

Shipping an external device to the CSP avoids network bandwidth limits but introduces transit time of days or weeks, during which the source database must remain authoritative, and the final cutover still risks data loss or extended downtime.

BCreate a replica database synchronize the data, and switch to the new instance.Correct

Creating a replica database and continuously synchronizing data to the new instance allows the migration to happen while the source database remains online and serving traffic. Once the replica is fully synchronized, the cutover - switching connections to the new instance - can be completed in seconds or a few minutes, well within the 10-minute SLA window. This technique, known as a live migration or online migration, is the standard approach when downtime constraints cannot accommodate a full data transfer window.

CUtilize a third-party tool to back up and restore the data to the new database

Using a third-party backup and restore tool would require the database to be taken offline for the full duration of the restore operation, which at 800 GB over 100 MBps would far exceed the 10-minute SLA.

DUse the database import/export method and copy the exported file.

The database import/export method requires exporting the full dataset, transferring it, and then importing it - a process that would take over two hours at 100 MBps and violates the 10-minute downtime constraint.

Concept tested: Online database migration with minimal downtime using replication

Source: https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql

Topics

#database migration#SLA constraints#replication#data sync

Community Discussion

No community discussion yet for this question.

Full CV0-003 Practice