Table of Contents
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?
A. Business Critical
B. Hyperscale
C. General Purpose
D. Premium
Answer
A. Business Critical
Explanation
The correct answer is A. Business Critical.
The Business Critical service tier is designed for applications with low I/O latency requirements and minimal impact of underlying maintenance operations on the workload. It uses local SSD storage to provide high performance and low latency for the data files. It also provides higher availability than the General Purpose tier by using an Always On availability group with four replicas.
The General Purpose service tier is the default service tier in Azure SQL Managed Instance designed for most of generic workloads. It has a storage latency between 5 and 10 ms, which is higher than the Business Critical tier. It also uses remote Azure Premium SSD storage for the data files, which may not provide the best performance for I/O intensive workloads.
The Hyperscale service tier is designed for applications that require high scalability and fast database growth. It supports up to 100 TB of storage and provides rapid scale-out and scale-in capabilities. However, it does not guarantee low disk latency as it also uses remote Azure storage for the data files.
The Premium service tier is not a valid option for Azure SQL Managed Instance. It is only available for Azure SQL Database single databases and elastic pools.
Reference
- What is Azure SQL Managed Instance? – Azure SQL Managed Instance | Microsoft Learn
- Resource limits – Azure SQL Managed Instance | Microsoft Learn
- vCore purchasing model – Azure SQL Managed Instance | Microsoft Learn
- sql-docs/azure-sql/managed-instance/service-tiers-managed-instance-vcore.md at live · MicrosoftDocs/sql-docs · GitHub
- Resource limits – Azure SQL Managed Instance | Microsoft Learn
- Storage: Performance best practices & guidelines – SQL Server on Azure VMs | Microsoft Learn
- Frequently asked questions (FAQ) – Azure SQL Managed Instance | Microsoft Learn
- Performance tuning guidance for applications and databases – Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn
- SQL Server to Azure SQL Managed Instance: Migration guide – Azure SQL Managed Instance | Microsoft Learn
- Key causes of performance differences between SQL managed instance and SQL Server | Azure Blog | Microsoft Azure
- SQL Server to Azure SQL Database: Migration guide – Azure SQL Database | Microsoft Learn
- SQL Server to SQL Managed Instance: Migration overview – Azure SQL Managed Instance | Microsoft Learn
- Tutorial: Migrate SQL Server to SQL Managed Instance – Azure Database Migration Service | Microsoft Learn
Administering Relational Databases on Microsoft Azure DP-300 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Administering Relational Databases on Microsoft Azure DP-300 exam and earn Administering Relational Databases on Microsoft Azure DP-300 certification.