Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 14 question 2 discussion

Actual exam question from Microsoft's DP-300

Question #: 2
Topic #: 14

HOTSPOT -
You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: Vcore -
Scenario:
✑ The 30 new databases must scale automatically.
✑ Once all requirements are met, minimize costs whenever possible.
You can configure resources for the pool based either on the DTU-based purchasing model or the vCore-based purchasing model.
In short, for simplicity, the DTU model has an advantage. Plus, if you're just getting started with Azure SQL Database, the DTU model offers more options at the lower end of performance, so you can get started at a lower price point than with vCore.
Box 2: An Azure SQL database elastic pool
Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in Azure SQL Database enable
SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.
Reference:
https://azure.microsoft.com/es-es/blog/a-flexible-new-way-to-purchase-azure-sql-database/ https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview

by elgaz at March 15, 2021, 1:56 a.m.

Comments

Submit Cancel

elgaz

Highly Voted 4 years, 3 months ago

Hybrid Use Benefits is not supported for DTU

upvoted 21 times

azskierphoto

4 years, 2 months ago

You are right Should be vCore https://azure.microsoft.com/es-es/blog/a-flexible-new-way-to-purchase-azure-sql-database/

upvoted 7 times

sid1805

3 years, 11 months ago

But we are talking about ~new database so not sure how would you reap license benefits?

upvoted 2 times

CaptainJameson

3 years, 4 months ago

It also says: "Azure Hybrid Use Benefits must be leveraged for Azure SQL Database deployments". Doesn't matter if they are new or migrated.

upvoted 3 times

...

bingomutant

Most Recent 8 months ago

For the given scenario, the correct recommendations would be: Purchasing model: vCore: This option offers more flexibility and control over resources such as CPU, memory, and storage. It allows scaling based on the exact needs of the workload and would be a suitable choice given the requirement for scalability. Deployment option: An Azure SQL Database elastic pool: Given the varying usage patterns of the 30 new databases, elastic pools would allow these databases to share resources. This solution helps optimize cost and performance by allowing resource flexibility across databases with different usage demands.

upvoted 2 times

voodoo_sh

3 months, 3 weeks ago

Agree. And vCore supports Hybrid use benefits, while DTU doesn't

upvoted 1 times

...

eric0718

3 years, 1 month ago

Purchasin model: vCore Deployment option: Elastic pool For Azure SQL Database, Azure Hybrid Benefit is only available when using the provisioned compute tier of the vCore-based purchasing model. Azure Hybrid Benefit doesn't apply to DTU-based purchasing models or the serverless compute tier. Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands.

upvoted 3 times

...

mnfatboy1

3 years, 5 months ago

The first comment that "Hybrid Use Benefits is not supported for DTU" is indeed true, but not applicable. These are 30 new databases. With that said - which licensing model (DTU or VCore) would Microsoft recommend as the Microsoft answer?

upvoted 1 times

...

xegiwo9758

3 years, 5 months ago

Purchasin model: vCore Deployment option: Elastic pool

upvoted 3 times

...

ramelas

3 years, 6 months ago

the answers are correct. DTU model is the one. The 30 databases will be new, not migrated to the cloud and you just need that license when you are migrating the databases. the databases must scale automaticly and in vcore model that is just possible when we have a serverless tier, not an option for this enviorment. DTU is the one

upvoted 1 times

...

erssiws

3 years, 10 months ago

The provided answer is not correct regarding the purchasing model, it should be vCore based, because vCore model allows more configuration possibilities to optimize the cost. The elastic pool option is correct.

upvoted 1 times

ramelas

3 years, 6 months ago

you need auto scale and that is just possible in serverless

upvoted 1 times

ramelas

3 years, 6 months ago

serverless in not an option

upvoted 1 times

...