DP-300 Certification Practice Question #49

Question

You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.

You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.

Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Accepted Answer

Azure SQL Managed Instance offers two service tiers (General Purpose and Business Critical) with three hardware series each (Standard, Premium, Premium Memory Optimized). For a 14-TB database, the service tier and hardware must support storage ≥14 TB. According to the MS Learn resource limits documentation, all three General Purpose series (Standard = A, Premium = C) support up to 16 TB. For Business Critical, only the Premium Memory Optimized series (B) broadly supports 16 TB, while Business Critical Standard (E) is limited to ~4 TB and Business Critical Premium (D) is region-dependent. The community most-voted answer of ABC is supported by the documentation and multiple highly-voted commenters.

More DP-300 practice questions