Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

You are designing the migration for a 6-TB SQL Server 2014 database that runs on-premises. The database uses SQL Agent jobs, Service Broker, linked servers, and cross-database queries. The business requires less than 15 minutes of downtime during cut-over and wants built-in high availability in Azure without having to patch or manage the operating system. A 1-Gbps ExpressRoute circuit is available, and firewall rules can be changed as needed. Which migration target and approach should you recommend?

  • Use Azure Database Migration Service for an online migration to Azure SQL Managed Instance in the Business Critical tier.

  • Back up the database to Azure Storage and restore it into Azure SQL Database Hyperscale.

  • Configure transactional replication to a SQL Server 2019 container running in Azure Kubernetes Service, then redirect clients at cut-over.

  • Use Azure Site Recovery to replicate the on-premises VM and fail over to SQL Server on Azure Virtual Machines deployed in an availability set.

Microsoft Azure Solutions Architect Expert AZ-305
Design infrastructure solutions
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot