Azure SQL Managed Instance Quiz

Quiz covering Deploy Azure SQL Solutions

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   Which Azure SQL deployment option provides near 100% compatibility with the latest SQL Server (Enterprise Edition) database engine, including native virtual network support?

2. 2

   You are deploying an Azure SQL Managed Instance and need to ensure it is placed in a dedicated subnet. What is a mandatory requirement for the subnet hosting the Managed Instance?

3. 3

   Which service tier in Azure SQL Managed Instance is best suited for workloads that require high availability and fast recovery from infrastructure failures, but do not require read-scale out or extreme low-latency storage?

4. 4

   When migrating an on-premises SQL Server to Azure SQL Managed Instance, which tool is recommended to assess compatibility and identify potential migration blockers?

5. 5

   You have a Managed Instance in the Business Critical tier. You need to offload read-only reporting queries to a secondary replica to reduce the load on the primary instance. How is this achieved?