BenchMark Quizzes by MDFT Pro

Select Service Tiers for 14-TB SQL Managed Instance

You work for MDFT Pro, a well-known training agency that operates an on-premises datacenter hosting a 14-TB Microsoft SQL Server database. This database contains all student records, course materials, trainer information, and certification tracking data accumulated over many years of operation. Mark, the Database Administrator, is planning to migrate the training agency’s infrastructure to Azure to improve scalability and reduce operational overhead.

You have been tasked with helping Mark create an Azure SQL Managed Instance and migrate the on-premises student records database to the new cloud instance. The solution must ensure the managed instance can accommodate the full 14 TB of data.

Which three service tiers support the SQL Managed Instance for this migration?

Choose all correct answers from the options below.

Explanations for each answer:

General Purpose Standard is correct. General Purpose Standard-series supports up to 16 TB of storage, which can accommodate the 14-TB database.
Business Critical Memory Optimized Premium is correct. Business Critical Premium-series Memory Optimized supports up to 16 TB of storage for the 14-TB database.
General Purpose Premium is correct. General Purpose Premium-series supports up to 16 TB of storage, making it suitable for the 14-TB database.
Business Critical Premium is incorrect. Business Critical Premium-series (non-Memory Optimized) has a maximum storage limit of 5.5 TB, which is insufficient for a 14-TB database.
Business Critical Standard is incorrect. Business Critical Standard-series has a maximum storage limit of 4 TB, which is insufficient for a 14-TB database.

Learn more about SQL Managed Instance resource limits:

SQL Managed Instance Resource Limits

Practice Exam

Select Service Tiers for 14-TB SQL Managed Instance

Discuss this question on social media: