Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Your company is developing a new reporting application that will use a single Azure SQL relational database. The workload is highly unpredictable: some days only a few dozen queries per hour, while month-end reporting drives thousands of concurrent requests for several hours. The database is rarely accessed overnight or on weekends. The data volume is expected to remain below 2 TB, and management wants to minimize compute cost while still meeting Azure SQL Database's 99.99 percent availability SLA. Which deployment option should you recommend?

  • Single database in the General Purpose tier with provisioned vCore compute.

  • Azure SQL Managed Instance deployed in the Business Critical service tier.

  • Single database in the Hyperscale tier with provisioned compute.

  • Single database in the General Purpose serverless compute tier with auto-pause enabled.

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