AZ-305 · Question #194
AZ-305 Question #194: Real Exam Question with Answer & 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.
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:
Options
- __typehotspot
- variantdropdown
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/
Community Discussion
No community discussion yet for this question.