nerdexam
Microsoft

AZ-305 · Question #194

Hotspot Question 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…

The correct answer is Purchase model:: vCore; Deployment option:: An Azure SQL Database elastic pool. This question tests knowledge of SQL Server licensing options in Azure, specifically how to minimize licensing costs while supporting automatic scaling for a Volume Licensing customer with License Mobility through Software Assurance.

Submitted by anna_se· Mar 6, 2026Design data storage solutions

Question

Hotspot Question 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. Answer:

Exhibit

AZ-305 question #194 exhibit

Answer Area

  • Purchase model:vCore
    DTUvCoreAzure reserved virtual machine instances
  • Deployment option:An Azure SQL Database elastic pool
    An Azure SQL managed instanceAn Azure SQL Database elastic poolA SQL Server Always On availability group

Explanation

This question tests knowledge of SQL Server licensing options in Azure, specifically how to minimize licensing costs while supporting automatic scaling for a Volume Licensing customer with License Mobility through Software Assurance.

Approach. The correct solution involves using Azure SQL Database Elastic Pools with the vCore purchasing model and Azure Hybrid Benefit. Elastic Pools support automatic scaling across multiple databases, making them ideal for 50 databases. Azure Hybrid Benefit allows Contoso to use their existing SQL Server licenses (covered under Software Assurance/License Mobility) to significantly reduce costs - up to 30% savings. The vCore model is required to apply Azure Hybrid Benefit, whereas the DTU model does not support it. This combination satisfies both requirements: automatic scaling via Elastic Pools and minimized licensing costs via Azure Hybrid Benefit leveraging existing SA-covered licenses.

Concept tested. SQL Server licensing optimization in Azure - specifically the use of Azure Hybrid Benefit with vCore-based purchasing models, Elastic Pools for automatic scaling, and how License Mobility through Software Assurance enables cost reduction for Volume Licensing customers deploying to Azure.

Reference. https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-vcore and https://azure.microsoft.com/en-us/pricing/hybrid-benefit/

Topics

#vCore purchase model#SQL elastic pool#License Mobility#Azure SQL Database

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice