ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 14 question 2 discussion

Actual exam question from Microsoft's DP-300
Question #: 2
Topic #: 14
[All DP-300 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
elgaz
Highly Voted 4 years, 1 month ago
Hybrid Use Benefits is not supported for DTU
upvoted 21 times
azskierphoto
4 years 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, 10 months ago
But we are talking about ~new database so not sure how would you reap license benefits?
upvoted 2 times
CaptainJameson
3 years, 2 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 6 months, 2 weeks 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
2 months, 1 week ago
Agree. And vCore supports Hybrid use benefits, while DTU doesn't
upvoted 1 times
...
...
eric0718
2 years, 11 months 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, 3 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, 3 months ago
Purchasin model: vCore Deployment option: Elastic pool
upvoted 3 times
...
ramelas
3 years, 5 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, 8 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, 4 months ago
you need auto scale and that is just possible in serverless
upvoted 1 times
ramelas
3 years, 4 months ago
serverless in not an option
upvoted 1 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago