BenchMark Quizzes by MDFT Pro

Select Service Tier To Minimize Disk Latency

You work for MDFT Pro, a well-known training agency planning to migrate an on-premises Microsoft SQL Server 2016 database named StudentRecords to Azure. Mark, the Performance Optimization Lead, has an Azure subscription and needs to create a new Azure SQL managed instance to host the migrated database. The StudentRecords database supports the company’s real-time student enrollment system, which processes thousands of concurrent transactions from students registering for courses, updating their profiles, and submitting assessments. The application is highly sensitive to disk latency, as even small delays impact the user experience and can cause timeouts during peak enrollment periods. Mark needs to select a service tier that minimizes disk latency to ensure optimal performance for the latency-sensitive workload.

Which service tier should you use?

Choose the correct answer from the options below.

Explanations for each answer:

Business Critical is correct. The Business Critical tier uses local SSD storage which provides the lowest disk latency, making it ideal for latency-sensitive workloads.
Hyperscale is incorrect. Hyperscale is designed for large databases but doesn't provide the same low latency as Business Critical with local SSD storage.
General Purpose is incorrect. General Purpose uses remote Azure Premium Storage which has higher latency than the local SSD storage used by Business Critical.
Premium is incorrect. Premium is not a service tier for Azure SQL Managed Instance. The correct tiers are General Purpose and Business Critical.

Learn more about Azure SQL Managed Instance Service Tiers:

SQL Managed Instance Service Tiers

Practice Exam

Select Service Tier To Minimize Disk Latency

Discuss this question on social media: