Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
You manage the database platform for a retail organization that operates 24/7. The primary 5-TB SQL Server 2016 database runs on-premises in an Always On availability group. Management has decided to move this database to Azure SQL Managed Instance. The business will tolerate no more than 30 minutes of total downtime during cut-over. Which Azure-based migration approach should you recommend to satisfy the downtime requirement while ensuring the target service remains fully managed?
Use Azure Database Migration Service deployed in the Premium tier to perform an online migration from the on-premises SQL Server to Azure SQL Managed Instance.
Enable Azure Site Recovery to replicate the on-premises SQL Server virtual machines to Azure and fail over to the replicas during the maintenance window.
Set up Azure SQL Data Sync between the on-premises database and Azure SQL Managed Instance, then cut over once synchronization is complete.
Export a BACPAC from the primary replica and import it into Azure SQL Managed Instance during the maintenance window.
Azure Database Migration Service (DMS) supports online migrations from on-premises SQL Server to Azure SQL Managed Instance when you deploy the service in the Premium tier. Online mode keeps the source database fully operational by continuously replicating changes until you choose to perform a brief cut-over-typically well under 30 minutes-for final synchronization and application redirection.
Exporting a BACPAC requires taking the source database offline and importing a single static snapshot, resulting in hours of downtime for a 5-TB database.
Azure Site Recovery replicates virtual machines, not managed database services; failing over would move the workload to an Azure VM-hosted SQL Server, not to Azure SQL Managed Instance, and still involves more downtime while the VM is brought online and clients are reconfigured.
Azure SQL Data Sync is designed for bidirectional data synchronization of selected tables and is neither intended for full-database migrations nor able to guarantee sub-hour cut-over windows for multi-terabyte workloads. Therefore, deploying Azure Database Migration Service in Premium tier with online migration is the only option that meets both the downtime constraint and the target platform requirement.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Azure Database Migration Service (DMS) and why is the Premium tier required for this migration?
Open an interactive chat with Bash
Why isn't exporting a BACPAC file suitable for a 5-TB database migration?
Open an interactive chat with Bash
What are the limitations of Azure SQL Data Sync in full-database migrations?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design infrastructure solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .