CV0-003 Question #882: Real Exam Question with Answer & Explanation

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.

Explanation

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.

Common mistakes.

A. 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.
C. 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.
D. 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

Reference. 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