Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

You are designing a cost-optimized architecture for a single Azure SQL Database that currently runs in the General Purpose service tier with 8 provisioned vCores. Telemetry shows that CPU utilization peaks at about 60 percent for two hours each weekday morning and remains below 5 percent for the rest of the day. The database is 200 GB and is expected to grow to 400 GB within a year. The solution must maintain the platform's 99.99 percent availability SLA and must not require any application changes. Which combination of service tier and compute tier should you recommend?

  • Upgrade the database to the Business Critical service tier with 8 provisioned vCores in a zone-redundant deployment.

  • Place the database in a General Purpose elastic pool that uses 8 provisioned vCores shared by a single database.

  • Migrate the database to the Hyperscale service tier with provisioned compute and enable autoscale read replicas.

  • Move the database to the General Purpose service tier with the serverless compute tier, configuring a low minimum vCore setting and auto-pause.

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