ExpertMedium1 markMultiple Choice
AZ-900 · Question 39 · Domain 2.6: Azure Database and Analytics Services
A company wants to migrate their on-premises Microsoft SQL Server to Azure without changing their application code. They need near 100% compatibility with the latest SQL Server engine. Which service should they choose?
A company wants to migrate their on-premises Microsoft SQL Server 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:
A.
Azure SQL Database
B.
Azure Cosmos DB
C.
Azure SQL Managed Instance
D.
Azure Database for MySQL
How to approach this question
Identify the service designed specifically for frictionless migration of on-premises SQL Server.
Full Answer
C.Azure SQL Managed Instance✓ Correct
Azure SQL Managed Instance
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.
Common mistakes
Choosing Azure SQL Database. While similar, SQL Database is a single database PaaS, whereas Managed Instance provides the full SQL Server instance experience needed for complex migrations.
Practice the full Azure Fundamentals AZ-900 Practice Exam 4
60 questions · hints · full answers · grading
More questions from this exam
Q01What is the primary definition of cloud computing?EasyQ02Under the shared responsibility model, which of the following is ALWAYS the responsibility of the...MediumQ03True or False: In a public cloud deployment model, you must purchase and manage your own physical...EasyQ04A company wants to move away from purchasing physical servers and instead pay monthly for the com...MediumQ05Which TWO of the following are primary benefits of using cloud computing? (Select TWO)Easy