Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

You are planning the migration of a multi-tenant SaaS application that currently runs on SQL Server 2016 Always On availability groups in your datacenter. Each tenant database is 20 GB today but could grow to 100 TB within a few years. The target service must allow up to four online readable replicas, automatically scale storage without redeployment, and retain backups for 35 days with minimal administration. Which Azure SQL deployment option should you recommend to meet these requirements?

  • SQL Server 2022 deployed on an Azure Virtual Machine with managed disks

  • Azure SQL Database elastic pool in the General Purpose tier

  • Azure SQL Managed Instance Business Critical tier

  • Azure SQL Database Hyperscale tier (single database)

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.

Bash, the Crucial Exams Chat Bot
AI Bot