DP-300 Certification Practice Question #152

Question

You have an Azure SQL managed instance named SQLMI1 that has the following settings:

•	vCores: 4
•	Service tier: General Purpose
•	Hardware generation: Standard-series (Gen5)

You discover that memory pressure on SQLMI1 is high.

You need to reduce the memory pressure on SQLMI1. The solution must minimize costs.

What should to do?

Accepted Answer

To reduce memory pressure on an Azure SQL Managed Instance while minimizing cost, you should optimize the memory-to-vCore ratio. Standard-series (Gen5) offers 5.1 GB of memory per vCore (resulting in 20.4 GB for 4 vCores), whereas Premium-series offers 7 GB of memory per vCore (resulting in 28 GB for 4 vCores, representing a ~37% memory increase). The cost of upgrading the hardware generation to Premium-series is significantly lower than doubling the vCores to 8 (which doubles the base compute and licensing costs) or moving to the Business Critical service tier. Enabling Query Store (Option A) has no impact on increasing available memory.

More DP-300 practice questions