exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 62 discussion

Actual exam question from Microsoft's AZ-305
Question #: 62
Topic #: 4
[All AZ-305 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 -
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.
Box 2: An Azure SQL Database elastic pool
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.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit https://docs.microsoft.com/ko-kr/azure/azure-sql/database/elastic-pool-overview

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
Malik007
Highly Voted 1 year, 10 months ago
Appear in exam. Answer is correct
upvoted 18 times
...
kay000001
Highly Voted 2 years, 2 months ago
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.
upvoted 16 times
...
SeMo0o0o0o
Most Recent 3 weeks, 1 day ago
CORRECT
upvoted 1 times
...
MSC_2022
1 year, 4 months ago
Appear in exam. Answer is correct
upvoted 6 times
...
NotMeAnyWay
1 year, 5 months ago
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.
upvoted 7 times
...
lombri
1 year, 6 months ago
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.
upvoted 1 times
...
zellck
1 year, 9 months ago
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.
upvoted 6 times
...
OPT_001122
1 year, 10 months ago
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
upvoted 3 times
...
darthfodio
1 year, 10 months ago
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.
upvoted 5 times
...
kastanov
1 year, 10 months ago
You cant use your licenses in Azure SQL Database. It should be managed instance
upvoted 1 times
testtaker13
1 year, 9 months ago
Doesn't look to be true. https://learn.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal
upvoted 1 times
...
...
arska
2 years ago
vCore and elastic pool. This link explains it all: https://www.microsoft.com/en-us/licensing/news/expanded-ahb-rights-for-microsoft-sql-server
upvoted 1 times
...
Snownoodles
2 years, 1 month ago
Given answer is correct MI doesn't support auto-scale
upvoted 2 times
...
Dinima
2 years, 2 months ago
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.
upvoted 4 times
Marciojsilva
2 years, 2 months ago
that´s true, I check on website "To set or update the license type using the Azure portal: For new managed instances, during creation, select Configure Managed Instance on the Basics tab and select the option for Azure Hybrid Benefit. For existing managed instances, select Compute + storage in the Settings menu and select the option for Azure Hybrid Benefit." https://learn.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal
upvoted 1 times
ronsav80
2 years, 2 months ago
See https://learn.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal ... "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."
upvoted 1 times
...
...
codefries
2 years, 2 months ago
managed instance does not support auto-scale: No, you need to choose reserved compute and storage. The change of service tier (vCore or max storage) is online and requires minimal or no downtime. https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
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
Loading ...