Administering Relational Databases on Microsoft Azure — Question 62

You have an Azure subscription.

You plan to provision a single Azure SQL database.

You need to ensure that the database supports the autoscaling of compute resources.

Which service tier should you choose?

Answer options

• A. Premium
• B. General Purpose
• C. Business Critical
• D. Standard

Correct answer: B

Explanation

The General Purpose service tier is designed to provide a balance of compute and storage options, allowing for autoscaling of compute resources. The Premium and Business Critical tiers offer higher performance but do not support autoscaling in the same way, while the Standard tier does not provide the same level of performance and features as General Purpose.