Exam DP-300 topic 1 question 30 discussion

Correct answer Business critical

This is a question for DP-300 👍 I hope we're good for the next questions now lol

A.Business Critical - you can't choose how many cores you need with DTU-based plans (Premium)

Business Critical allows to select number of vCores (we need 24 here), while in Premium you only see "DTUs".

Just a Note that while swapping between v-Core and DTU is permitted, it is not possible if the tier is using Hyperscale: https://learn.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?view=azuresql&tabs=azure-portal#:~:text=A%20database%20migrated%20to%20the%20vCore%2Dbased%20purchasing%20model%20can%20be%20migrated%20back%20to%20the%20DTU%2Dbased%20purchasing%20model%20at%20any%20time%20using%20the%20same%20steps%2C%20except%20for%20databases%20migrated%20to%20the%20Hyperscale%20service%20tier. Answer is correct, Business Critical

Answer is business Critical. Requirements in question has specific CPU, memory and Storage during peak season and the ONLY option that meets this requirement is Vcore purchasing model --> "Business Critical Service Tier". I know question says Azure database will be switched to "Standard tier" (DTU purchasing model) during OFF peak season. Its easy to swap between V core and DTU purchasing models without any downtime to Azure sql database, which meets requirements and makes the service tier change easy between Peak and OFF peak seasons. I Strongly agree the answer is "Business Critical". REASON I say "Premium" CANNOT be answer is because it is part of DTU purchasing model which makes it challenging to accommodate the requirement of specific CPU, memory and storage need during peak season because DTU model comes with resources that can be adjusted with predefined configuration which DOESNOT meet asked requirements in the question about CPU, RAM and Storage

as requirement has specific CPU, memory and Storage during peak hours, only option that meets this requirement is Vcore purchasing model --> "Business Critical Service Tier". I know question says "Standard tier" (DTU purchasing model) when OFF peak season and as it's easy to swap between V core and DTU purchasing models without any downtime to Azure sql database, which meets requirements. I Strongly agree the answer is "Business Critical". REASON I say "Premium" CANNOT be answer is because it is part of DTU purchasing model which makes it challenging to accommodate the requirement of specific CPU, memory and storage need during peak season because DTU model comes with resources that can be adjusted with predefined configuration which DOESNOT meet asked requirements in question about CPU, RAM and Storage

In DTU option you can't choose vCores and memory. You can do that in Business Critical option only. Here you can see 24vCores and 124GB of RAM: https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/

Business Critical is a feature of Premium tier. so correct answer is Premium.

Since we can switch from vCore to DTU, any choice can be valid. Based on configuration, I think the service tier is Business Critical with minimum BC_Gen5_24

https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql

i think answer is correct, because only with vcore you can separately configure compute,storage etc(and here we have specific requirements for each resource). and you can easily switch between dtu and vcore back and forth

I think A

I believe that correct answer is A (Business critical in vCore purchasing model) because we have request to scale up and down not only in compute resources but also a storage which is available only vCore purchasing model. Hyperscale is not suits us well as well because it is reversable only within 45 days of the original migration to Hyperscale. Links https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql and https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql

The answer is A

Migrate a database Migrating a database from the DTU-based purchasing model to the vCore-based purchasing model is similar to scaling between service objectives in the Basic, Standard, and Premium service tiers, with similar duration and a minimal downtime at the end of the migration process. A database migrated to the vCore-based purchasing model can be migrated back to the DTU-based purchasing model at any time in the same fashion, with the exception of databases migrated to the Hyperscale service tier. https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?view=azuresql

Business Critical tier is called Premium in the DTU purchasing model.