Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

An insurance company runs a mission-critical policy administration system on SQL Server 2017 Enterprise Edition. The database uses SQL Agent jobs, cross-database queries, SQL CLR procedures, and Service Broker messaging. To reduce operational overhead, the company will migrate to Azure, requiring automatic backups, built-in high availability, and minimal code changes in a platform as a service (PaaS) model. Which Azure data service should you recommend?

  • Azure SQL Database elastic pool in the Premium tier

  • Azure SQL Managed Instance in the General Purpose tier

  • SQL Server 2022 on an Azure Virtual Machine protected by Azure Backup

  • Azure SQL Database single database in the Business Critical tier

Microsoft Azure Solutions Architect Expert AZ-305
Design data storage 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