Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

You are designing the data storage layer for a multi-tenant SaaS application that on-boards and off-boards customer databases frequently. Each tenant requires its own relational database. Workload is unpredictable: databases can be idle for hours and then experience sudden bursts of activity. Management mandates the following:

  • Minimize cost during idle periods without manual intervention.
  • Automatically scale compute based on workload demand.
  • Achieve an SLA of 99.99 percent availability per database. Which Azure SQL offering should you recommend for the tenant databases?
  • Azure Database for MySQL flexible server in the Burstable tier

  • Azure SQL Database provisioned vCore in an elastic pool

  • Azure SQL Database in the serverless compute tier

  • Azure SQL Managed Instance (General Purpose tier) with autoscale 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.

Bash, the Crucial Exams Chat Bot
AI Bot