First question of this test topics about if we need storage account everyone answer yes for azure sql MI migration now we're talking about azure sql DB
Correct Answer: D
Purchasing Model: vCore-based
Service Tier: General Purpose or Hyperscale
Compute Tier: Serverless
Scenarios well suited for serverless compute
Single databases with intermittent, unpredictable usage patterns interspersed with periods of inactivity, and lower average compute utilization over time.
https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose
Two issues
- use of own licenses wherever possible is available for sql elastic pool. See SQL Database Hybrid Benefits Calculator (drop down database to elastic pool) https://azure.microsoft.com/en-gb/pricing/hybrid-benefit/#features
- unpredictable usage pattern which necessitates an elastic pool
Just my two pennies
Of course the problem is that elastic pool is meant to pool resources amongst many databases and not a single one. So in order to deal with the second issue of unpredictablity we can go for vCore with Dynamic scaling - see: https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-scale?view=azuresql&tabs=azure-portal
So I am changing my answer to D
D. vCore-based SQL
Requirement: Use existing on-premises licenses whenever possible
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.
In my opinion is A because of the migration. It has to be ONLINE. As Far as I know we have several tool to migrate DB. DMA, ADS, DMS and Azure Migrate. DMA only supports OFFLINE, ADS supports ONLINE and OFFLINE but does not work with Azure SQL DB, DMS supports ONLINE and OFFLINE but for Azure SQL DB only OFFLINE and Azure Migrate normally uses ADS or DMS depending on requirements.
To make the long story short, it cannot be Azure SQL DB. It could be Azure SQL MI but I do not see that option. So it is SQL in Azure VM.
Why the hell you choose D? You can use Azure Hybrid Benefit for Azure SQL Database elastic pool + they have high and low utilization scenarios, hence elastic pool will be the best option. Answer C IMHO is correct
Hyperscale service tier is available for single databases that are using the vCore-based purchasing model.
Rapid scale out and scale up options are available for unpredictable load.
A Hyperscale database grows as needed - and you're billed only for the capacity you use. For read-intensive workloads, the Hyperscale service tier provides rapid scale-out by provisioning additional replicas as needed for offloading read workloads.
https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql
Given answer looks correct as per article, which discusses auto-scale with serverless compute tier
https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql
C. Elastic Pool. Perfectly matches the description of the answer listed. The use case also mentioned databases plural being migrated and unpredictable usage. Also you can setup regional auto failover groups for SQL Database and Elastic Pools, so that would cover the geo-redundancy requirement. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql
It does state in the case study blurb : "To avoid disrupting customer access, database downtime must be minimized when *databases* are migrated." Because it says "databases", I think Elastic Pools is a viable option here.
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.
jellybiscuit
Highly Voted 2 years, 2 months agoSeMo0o0o0o
Most Recent 3 weeks, 6 days agoKarimaMaf
3 months, 2 weeks agogo4adil
7 months, 2 weeks agochair123
9 months agoayadmawla
11 months, 1 week agoayadmawla
11 months, 1 week agoziggy1117
1 year agobabakeyfgir
1 year agoxxavimr
1 year, 2 months agosawanti
1 year, 3 months agosjb666
1 year, 7 months agopkkalra
1 year, 10 months agoRandomNickname
1 year, 10 months agohonzar
1 year, 11 months agoSnownoodles
2 years, 1 month agoWickedMJ
2 years, 2 months agoezfix
2 years, 2 months agoFabrityDev
1 year, 10 months agoJay_2pt0
2 years, 1 month agokodathedog
1 year ago