Exam DP-300 topic 3 question 51 discussion

SQL MI in West US 3 region: General Purpose Standard (1TB Disk) - 4 vCore - 20.4 GB memory - $850 General Purpose Standard (1TB Disk) - 8 vCore - 40.8 GB memory - $1586 General Purpose Premium (1TB Disk) - 4 vCore - 28 GB memory - $920 Business Critical Standard (1TB Disk) - 4 vCore - 20.4 GB memory - $2232 Definitely not D, Business Critical is too expensive. C helps to minimize costs, lets hope that extra 8 GB will fix the problem :D

Used pricing calculator, C is cheaper and there is a memory increase

The asnwer doesn't make sense. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql What we have from the Pricing Calculator: Central US GP 4 vCore Standard 533.37$, memory 4*5.1=20.4GB A. no comments B. vCores = 8, memory = 8*5.1 = 40.8 - greater, so fine, the cost 1066.74$ C. Premium vCores = 4, memory = 4*7 = 28 - greater, so fine, the cost 630.72$ D. BC vCores = 4, memory = 4*5.1 = 20.4 - the same, not ok. 28GB might not reduce the pressure, though 40.8GB might not reduce either. Therefore, 2 conditions of the task: 1. increase memory, 2. the lowest price. So the answer must be C.

Why Other Options Are Less Suitable A. Enable the Query Store: Enabling the Query Store is primarily used for performance monitoring and tuning. It doesn't directly reduce memory pressure and may actually increase memory usage slightly due to additional overhead. C. Change Hardware Generation to Premium-series: Changing the hardware generation to Premium-series would increase costs significantly without a direct increase in memory allocation unless coupled with more vCores. Premium-series hardware may offer improved performance and features but doesn't specifically address memory pressure by itself. D. Change Service Tier to Business Critical: Switching to the Business Critical tier significantly increases costs and is designed to improve performance, redundancy, and availability. It provides better IOPS and latency but may not be necessary if the primary issue is memory pressure.

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

The correct answer is (A). The Query Store option is a cost-effective way to reduce memory pressure on a managed Azure SQL instance. The Query Store stores temporary data used by queries in the cloud, reducing the memory requirements of the managed Azure SQL instance.

I think it should be A.

Answer should be: C. Change Hardware generation to Premium-series. Business critical tier would be too expensive compared to changing the hardware type. Also, changing the number of vcores would not resolve any memory-related issues.