Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Your company runs an OLTP workload in an Azure SQL Database single database (General Purpose, 4 vCores) that stores 2 TB of data. Workload traffic can spike unpredictably, and the database must be able to add compute capacity within seconds to maintain SLAs. Forecasts show the data volume may grow beyond 50 TB within two years. Management wants the simplest option that requires minimal application changes while providing the fastest online scaling for both compute and storage. Which Azure SQL option should you recommend?

  • Deploy SQL Server 2022 on Azure Virtual Machines inside an availability set and use Virtual Machine Scale Sets for compute elasticity.

  • Move the database to an Azure SQL Database General Purpose serverless tier inside an elastic pool with auto-pause enabled.

  • Migrate the database to Azure SQL Managed Instance Business Critical tier and enable an auto-failover group.

  • Migrate the database to Azure SQL Database in the Hyperscale service tier and use its rapid scale-up and read-scale out capabilities.

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