Exam AZ-305 topic 4 question 62 discussion

Appear in exam. Answer is correct

Answers are correct. VCore - With the provisioned compute, you can choose the amount of compute resources that are always provisioned for your workload. With the serverless compute you can specify the autoscaling of the compute resources over a configurable compute range. Support automatic scaling - elastic pool.

CORRECT

Appear in exam. Answer is correct

Purchase Model: b. vCore Deployment option: b. an Azure SQL Database elastic pool Explanation: a. Purchase Model: The vCore model provides a more direct way to choose compute and storage resources, and it can offer cost savings. The vCore-based purchasing model also allows you to use Azure Hybrid Benefit to save on licensing costs. b. Deployment option: Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. Elastic pools enable you to purchase resources for a pool shared by multiple databases to accommodate unpredictable periods of usage by individual databases. You can allocate exactly the resources you need for your databases in a flexible, budget-friendly way.

License Mobility through Software Assurance enhances the value of volume licenses with Software Assurance by extending their use to the cloud. This benefit can also help you lower your operating costs by using an Authorized Mobility Partner’s shared infrastructure.

1. vCore 2. An Azure SQL DB elastic pool https://learn.microsoft.com/en-us/azure/azure-sql/database/purchasing-models?view=azuresql#purchasing-models vCore-based - This model allows you to independently choose compute and storage resources. The vCore-based purchasing model also allows you to use Azure Hybrid Benefit for SQL Server to save costs. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql 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 SQL Database enable software as a service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.

The answer is correct Box 1: vCore - Azure Hybrid Benefit isn't available for service tiers under the DTU-based purchasing model or for the serverless compute tier. Box 2: An Azure SQL Database elastic pool MI does not support auto scaling

The answer is correct, but I'm still trying to understand why an Azure Solutions Architect would be "managing" a database, or any resources for that matter. This common across MSFT cert exams. Much overlap in role responsibilities in these specialty exams.

You cant use your licenses in Azure SQL Database. It should be managed instance

vCore and elastic pool. This link explains it all: https://www.microsoft.com/en-us/licensing/news/expanded-ahb-rights-for-microsoft-sql-server

Given answer is correct MI doesn't support auto-scale

I feel the answer for this is managed instance, as only that supports bring your own licensing. Elastic pool is an option with azure sql which doesn't provide the option use the existing licensing.