DP-300 Certification Practice Question #40

Question

You have an Azure subscription.

You need to deploy an Azure SQL managed instance that meets the following requirements:

•	Optimize latency.
•	Maximize the memory-to-vCore ratio.

Which service tier and hardware generation should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The question requires two things: optimize latency AND maximize memory-to-vCore ratio. Business Critical is the only SQL MI tier with locally-attached SSD storage (lowest latency), ruling out General Purpose and Hyperscale. For hardware, Premium-series memory-optimized specifically provides the highest memory-to-vCore ratio of the three options, making it the clear selection. Both top commenters confirm this combination matches the official answer.

More DP-300 practice questions