Exam DP-300 topic 1 question 50 discussion

Actual exam question from Microsoft's DP-300

Question #: 50
Topic #: 1

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?

A. the Business Critical service tier
B. the serverless compute tier
C. an elastic pool
D. the General Purpose service tier

Show Suggested Answer

Suggested Answer: B 🗳️

by Pranava_GCP at April 17, 2023, 3:04 a.m.

Comments

Submit Cancel

DataSturdy

1 year, 1 month ago

B. Serverless compute tier is correct as it allows for auto pause

upvoted 3 times

...

Pranava_GCP

2 years, 3 months ago

Selected Answer: B

B is correct, 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. above statements from below link https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose

upvoted 4 times

...