Administering Relational Databases on Microsoft Azure — Question 36

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?

Answer options

Correct answer: B

Explanation

The correct choice is B, the serverless compute tier, as it allows for automatic scaling of CPU resources and the ability to pause during inactivity, thus saving costs. Options A and D, the Business Critical and General Purpose service tiers, do not offer the pausing capability, while option C, an elastic pool, is more suitable for managing multiple databases rather than individual scaling and pausing.