DP-300 Certification Practice Question #39

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?

Accepted Answer

The serverless compute tier is the only Azure SQL Database option that simultaneously offers dynamic CPU auto-scaling and the ability to auto-pause when idle (billing only for storage during paused periods). While serverless currently only operates within the General Purpose service tier, the correct answer to the specific question about "dynamically scaling CPU and enabling pause" is the serverless compute tier (B). All primary signals align on B.

More DP-300 practice questions