Knowledge check

Choose the best response for each of the questions below. Then select Check your answers.

Check your knowledge

Which tool would you use to assess and migrate your databases from an on-premises SQL Server to an Azure Virtual Machine?

Microsoft Assessment and Planning Toolkit

Database Experimentation Assistant

Data Migration Assistant

What does Microsoft guarantee if you upgrade versions of SQL Server but maintain the same compatibility level, on similar hardware?

Syntax compatibility

Execution Plan Shape

Elapsed time of queries

What is a valid reason for migrating your database to Azure SQL Database?

Your applications need to run older versions of SQL Server, such as SQL Server 2016

You want to eliminate the complexity of configuring and managing high availability, backups, and other database tasks

You want to improve query performance of your application

You must answer all questions before checking your work.