ExpertMedium1 markMultiple Choice
AZ-900 · Question 39 · Domain 2.6: Azure Database and Analytics Services
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?
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:
A.
Azure SQL Database
B.
Azure SQL Managed Instance
C.
Azure Cosmos DB
D.
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
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.
Practice the full Azure Fundamentals AZ-900 Practice Exam 5
60 questions · hints · full answers · grading
More questions from this exam
Q01What is the best definition of cloud computing?EasyQ02According to the shared responsibility model, which of the following is ALWAYS the responsibility...MediumQ03Which cloud model combines on-premises infrastructure with a public cloud, allowing data and appl...EasyQ04True or False: Moving to a public cloud typically requires a significant upfront Capital Expendit...EasyQ05An e-commerce website experiences a sudden spike in traffic during a holiday sale. The system aut...Medium