Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Your company is building a multi-tenant SaaS application hosted in Azure. Each tenant will have its own Azure SQL Database. During off-hours most databases are idle, but at unpredictable times individual tenants can require as much as 4 vCores for several hours. Management wants to minimize compute cost when databases are idle and avoid any manual scaling operations. Which Azure SQL deployment and tier combination should you recommend?
Azure SQL Database single database using the serverless compute tier in the Hyperscale service tier
Azure SQL Database single database using the serverless compute tier in the General Purpose service tier
Azure SQL Database elastic pool using the provisioned compute tier in the Business Critical service tier
Azure SQL Managed Instance using the provisioned compute tier in the General Purpose service tier
The Azure SQL Database serverless compute tier in the General Purpose service tier is designed for workloads with intermittent or unpredictable usage patterns. It automatically scales compute between a configurable minimum and maximum (0.5 - 40 vCores on Gen5) and can automatically pause after a user-defined period of inactivity, at which point billing stops for compute and continues only for storage. Serverless is currently supported only for single databases. Hyperscale serverless is still in preview, provisioned tiers continue to incur compute charges even when idle, and Azure SQL Managed Instance does not offer a serverless option.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the serverless compute tier in Azure SQL Database?
Open an interactive chat with Bash
What is the difference between General Purpose and Hyperscale service tiers?
Open an interactive chat with Bash
Why is serverless more cost-effective for idle databases?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design data storage solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .