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

Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam
Go to Exam

Exam AZ-304 topic 3 question 1 discussion

Actual exam question from Microsoft's AZ-304
Question #: 1
Topic #: 3
[All AZ-304 Questions]

HOTSPOT -
You manage a database environment for a Microsoft Volume Licensing customer named Contoso, Ltd. Contoso uses License Mobility through Software
Assurance.
You need to deploy 50 databases. The solution must meet the following requirements:
✑ Support automatic scaling.
✑ Minimize Microsoft SQL Server licensing costs.
What should you include in the solution? 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 -
Virtual core (vCore)-based purchasing model (recommended). This purchasing model provides a choice between a provisioned compute tier and a serverless compute tier. With the provisioned compute tier, you choose the exact amount of compute resources that are always provisioned for your workload. With the serverless compute tier, you specify the autoscaling of the compute resources over a configurable compute range
Box 2: An Azure SQL Database Elastic pool
Azure SQL Database provides the following deployment options for a database:
✑ Single database represents a fully managed, isolated database.
✑ Elastic pool is a collection of single databases with a shared set of resources, such as CPU or memory. Single databases can be moved into and out of an elastic pool.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models
by Ario at Sept. 30, 2021, 10:03 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
leo_az300
Highly Voted 3 years, 6 months ago
R1: Support automatic scaling This is definitely Elastic Pool. Both DTU and vCore support exlastic pool. R2: Minimize Microsoft SQL Server licensing costs But question mentioned License with software assurance. Therefore you can use Azure Hybrid Benefit for your Azure SQL database. In the provisioned compute tier of the vCore-based purchasing model, you can exchange your existing licenses for discounted rates on Azure SQL Database and Azure SQL Managed Instance by using Azure Hybrid Benefit. So purchase mode should be vCore. vCore & Elastic pool
upvoted 38 times
rdemontis
3 years, 5 months ago
thanks for explanation
upvoted 3 times
...
rdemontis
3 years, 5 months ago
And can confirm with microsoft documentation: https://docs.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?tabs=azure-powershell
upvoted 3 times
...
anupam77
3 years, 1 month ago
Correct. Enable Azure Hybrid Benefit Azure SQL Database You can choose or change your licensing model for Azure SQL Database using the Azure portal or the API of your choice. You can only apply the Azure Hybrid licensing model when you choose a vCore-based purchasing model and the provisioned compute tier for your Azure SQL Database. Azure Hybrid Benefit isn't available for service tiers under the DTU-based purchasing model or for the serverless compute tier. https://docs.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?tabs=azure-powershell
upvoted 4 times
...
...
tteesstt
Highly Voted 3 years, 6 months ago
DTU is cheaper but you need vCore model to apply hybrid benefits. What is Azure Hybrid Benefit for SQL Server, and am I eligible for it? https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/elastic/
upvoted 9 times
...
haazybanj
Most Recent 2 years, 5 months ago
Answer is correct
upvoted 1 times
...
AubinBakana
2 years, 8 months ago
Thsi option "Minimize Microsoft SQL Server licensing costs." pretty much threw me off thinking as I thought this alone force the choice to be a full SQL Server on a VM. I guess I didn't understand. I think they should have said SQL License to avoid confusion but I will not make the mistake again. Thank you for the explanation.
upvoted 1 times
...
kanweng
3 years, 1 month ago
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.
upvoted 1 times
...
waqas
3 years, 6 months ago
Given answers are correct.
upvoted 1 times
...
syu31svc
3 years, 6 months ago
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models Virtual core (vCore)-based purchasing model (recommended). This purchasing model provides a choice between a provisioned compute tier and a serverless compute tier. With the provisioned compute tier, you choose the exact amount of compute resources that are always provisioned for your workload. With the serverless compute tier, you specify the autoscaling of the compute resources over a configurable compute range vCore as purchasing model "deploy 50 databases" elastic pool for deployment
upvoted 2 times
...
roky
3 years, 7 months ago
I think the answer might be DTU or vCore and sql elastic pool refer these https://docs.microsoft.com/ko-kr/azure/azure-sql/database/elastic-pool-overview#how-do-i-choose-the-correct-pool-size
upvoted 2 times
sjai
3 years, 6 months ago
In the provisioned compute tier of the vCore-based purchasing model, you can exchange your existing licenses for discounted rates on Azure SQL Database and Azure SQL Managed Instance by using Azure Hybrid Benefit https://docs.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?tabs=azure-powershell
upvoted 1 times
...
...
monkalways
3 years, 7 months ago
Answer is correct.
upvoted 1 times
...
Ario
3 years, 7 months ago
Deployment option should be : SQL Managed Instance : SQL Managed Instance uses vCores mode and enables you to define maximum CPU cores and maximum of storage allocated to your instance. All databases within the managed instance will share the resources allocated to the instance. https://docs.microsoft.com/en-us/azure/azure-sql/database/scale-resources
upvoted 2 times
Sathya22
3 years, 6 months ago
In this question , it is not mentioned whether migration is happening . So Definitely SQL managed instance is not the answer
upvoted 1 times
...
monkalways
3 years, 7 months ago
Disagree. Deployment option should be elastic pool, which supports vCore-based purchasing model too. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview#:~:text=%20Creating%20a%20new%20SQL%20Database%20elastic%20pool,pool%20to%20create%20a%20pool%20directly...%20More%20
upvoted 2 times
Ario
3 years, 7 months ago
You are right with elastic pool we save some money which required in this question
upvoted 2 times
...
...
TheAzureArchitect
3 years, 5 months ago
Managed instance is the answer when you need near 100% compatibility with an existing on-prem deployment of SQL. The question does not mention migration of a solution so managed instance is not the solution.
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