DP-300 Certification Practice Question #38

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?

Accepted Answer

Azure SQL Managed Instance offers two primary service tiers: General Purpose (uses remote Azure Premium Storage, higher latency) and Business Critical (uses local SSD-attached storage, lowest latency). The question requires minimizing disk latency, which unambiguously points to Business Critical. Both Hyperscale and Premium are inapplicable to SQL MI. All 12 community votes, the Suggested Answer, and multiple high-upvote comments agree unanimously on A.

More DP-300 practice questions