Exam DP-300 topic 1 question 62 discussion

as of 2024/12/11 - A,B,C,D support up to 16 TB - according to this doc: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql#hardware-configuration-characteristics

I have two SQL MI - one at West US 2 and one at West US 3. General purpose are all up to 16 GB: - standard (up to 16 TB) - premium (up to 16 TB) - premium memory optimized (up to 16 TB) Business Critical show different limits, depending on region: West US 2: Business Critical - standard (up to 4 TB) - premium (up to 16 TB) - premium memory optimized (up to 16 TB) West US 3: Business Critical - standard (up to 4 TB) - premium (up to 5.5 TB) - premium memory optimized (up to 5.5 TB) It means at West US 2 answer is: A, B, C, D And at West US 3 answer is: A, C Bad job by Microsoft on such question. Hope won't get it at exam.

By today, Business Critical Premium non-optimized is also supporting up to 16TB (I can literally see it in my Azure account UI). I hope they do not include this question in exam anymore, because hardware specs seem to grow more and more with time flow

Answer is correct. Only Memory optimized premium-series in Business Critical tier supports up to 16TB, unlike all three series for General Purpose. https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-sql-server-agent-proxy?view=sql-server-ver16

These service tiers do not have the "Standard" or "Premium" distinction that is common with other Azure SQL offerings like Azure SQL Database.

answer is perfect https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql

Answer is correct, you can confirm this with the Azure cost calculator. https://azure.microsoft.com/en-us/pricing/calculator/ SQL MI supports: Service Tier: 1. General Purpose 2. Business Critical Hardware Type: 1. Standard-series 2. Premium-series 3. Premium-series, memory optimized