Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam

Exam AZ-304 topic 3 question 1 discussion

Actual exam question from Microsoft's AZ-304

Question #: 1
Topic #: 3

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

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

Submit Cancel

leo_az300

Highly Voted 3 years, 8 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, 6 months ago

thanks for explanation

upvoted 3 times

...

rdemontis

3 years, 6 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, 3 months 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, 8 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, 7 months ago

Answer is correct

upvoted 1 times

...

AubinBakana

2 years, 10 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, 2 months 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, 8 months ago

Given answers are correct.

upvoted 1 times

...

syu31svc

3 years, 8 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, 8 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, 8 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, 8 months ago

Answer is correct.

upvoted 1 times

...

Ario

3 years, 8 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, 8 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, 8 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, 8 months ago

You are right with elastic pool we save some money which required in this question

upvoted 2 times

...

TheAzureArchitect

3 years, 7 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

...