A company wants to migrate their on-premises SQL Server database to Azure without changing their application code. They need near 100% compatibility with the latest SQL Server engine. Which service should they choose?

Answer options:

Azure SQL Database

Azure SQL Managed Instance

Azure Cosmos DB

Azure Synapse Analytics

How to approach this question

Look for 'migrate from on-premises' and 'near 100% compatibility'.

Full Answer

B.Azure SQL Managed Instance✓ Correct

Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. It is the best option for 'lift and shift' migrations.

Common mistakes

Choosing Azure SQL Database. SQL Database is a PaaS offering optimized for modern cloud applications, but it lacks some legacy features required by older on-premises apps.

Question 38 All questions Question 40

Practice the full Azure Fundamentals AZ-900 Practice Exam 5

60 questions · hints · full answers · grading

A company wants to migrate their on-premises SQL Server database to Azure without changing their application code. They need near 100% compatibility with the latest SQL Server engine. Which service should they choose?

How to approach this question

Full Answer

Common mistakes

Practice the full Azure Fundamentals AZ-900 Practice Exam 5

More questions from this exam