Azure SQL Managed Instance Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Deploy Azure SQL Solutions

What you'll be asked

  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. 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. 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. 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. 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?

Answers and explanations come after you submit.