Skip to main content
  1. Public practice questions
  2. AZ-900 Practice Exams | Azure Fundamentals
  3. Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

Question 291 — Domain 2-Describe Azure architecture and services | AZ-900 Practice Exam | 399 Questions

An Azure user seeks a fully managed SQL Server instance hosted by Microsoft as a PaaS service. How does Azure SQL Managed Instance enable the user to migrate new applications to the cloud without significant application changes? (Select 1 answer).

  1. By offering frictionless lift-and-shift scenarios

  2. By offering full isolation and security

  3. By offering a PaaS solution that focuses solely on databases and data

  4. By offering elastic databases and data pools

Correct answers

  1. By offering frictionless lift-and-shift scenarios

Explanations

Correct:
By offering frictionless lift-and-shift scenarios
Azure SQL Managed Instance provides near 100% compatibility with SQL Server on-premises, enabling seamless lift-and-shift migrations of applications to the cloud without extensive rewrites or modifications.

Wrong:
By offering full isolation and security
While Azure SQL Managed Instance includes robust security features, the focus here is on ease of migration rather than isolation or security.

By offering a PaaS solution that focuses solely on databases and data
Although it is a PaaS offering, Azure SQL Managed Instance’s value lies in enabling application migrations, not just focusing on databases.

By offering elastic databases and data pools
Elastic databases and data pools are features of Azure SQL Database, not specific to SQL Managed Instance.