You have an Azure subscription. You need to deploy an Azure SQL database. The solution must meet the following requirements: - Dynamically scale CPU resources. - Ensure that the database can be…

The correct answer is B. the serverless compute tier. Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when…

Submitted by kim_seoul· Mar 6, 2026Plan and implement data platform resources

Question

You have an Azure subscription. You need to deploy an Azure SQL database. The solution must meet the following requirements: - Dynamically scale CPU resources. - Ensure that the database can be paused to reduce costs. What should you use?

Options

Athe Business Critical service tier
Bthe serverless compute tier
Can elastic pool
Dthe General Purpose service tier

How the community answered

(57 responses)

A
5% (3)
B
82% (47)
C
2% (1)
D
11% (6)

Explanation

Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. The serverless compute tier is available in the General Purpose service tier and currently in preview in the Hyperscale service tier. https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier- overview?view=azuresql&tabs=general-purpose

Topics

#serverless tier#auto-pause#dynamic scaling#Azure SQL Database

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice