Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

You administer an 8-TB Microsoft SQL Server 2012 database that supports a mission-critical retail application running 24 hours a day. The business has approved moving this workload to Azure SQL Managed Instance. During the move you must keep the source database fully operational, guarantee transactional consistency, and limit the final cutover to less than two hours. Which migration approach should you recommend?

  • Export the on-premises database to a BACPAC file, upload it to Azure Storage, and import it into Azure SQL Managed Instance during maintenance.

  • Implement SQL Server log shipping to an Azure SQL virtual machine and restore the logs to Azure SQL Managed Instance during the cutover window.

  • Provision Azure Database Migration Service in the Premium tier and perform an online migration to Azure SQL Managed Instance, then execute a brief controlled cutover.

  • Create a Data Factory pipeline that incrementally copies tables to an Azure SQL Database, then repoint the application to the new endpoint.

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