Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

You are designing a new relational data tier for a multi-tenant SaaS application running in Azure. The workload is read-heavy, experiences unpredictable spikes, and is forecast to grow from 1 TB today to more than 15 TB over the next 18 months. The solution must allow rapid, non-blocking compute scale-out for reporting queries and must let you increase storage capacity on demand without lengthy migrations. Which Azure SQL deployment option meets the requirements?

  • Use an Azure SQL Managed Instance in the Business Critical tier with read-scale-out enabled.

  • Deploy a single Azure SQL Database in the Hyperscale service tier.

  • Deploy a single Azure SQL Database in the Premium tier and configure active geo-replication.

  • Place the database in an Azure SQL elastic pool using the General Purpose serverless 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.

Bash, the Crucial Exams Chat Bot
AI Bot