Microsoft
DP-300 · Question #223
Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1. You have an Azure subscription. You plan to migrate db1 to an Azure SQL managed instance. You need
The correct answer is D. Business Critical. General purpose has disk latency, Business critical puts the logs on SSD, Premium is a DTU offering which is not supported on Azure SQL MI, Hyperscale is not on Managed Instance.
Submitted by the_admin· Mar 6, 2026Plan and implement data platform resources
Question
Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1. You have an Azure subscription. You plan to migrate db1 to an Azure SQL managed instance. You need to create the SQL managed instance. The solution must minimize the disk latency of the instance. Which service tier should you use?
Options
- AHyperscale
- BGeneral Purpose
- CPremium
- DBusiness Critical
How the community answered
(67 responses)- A7% (5)
- B4% (3)
- C16% (11)
- D72% (48)
Explanation
General purpose has disk latency, Business critical puts the logs on SSD, Premium is a DTU offering which is not supported on Azure SQL MI, Hyperscale is not on Managed Instance.
Community Discussion
No community discussion yet for this question.