Microsoft Azure Data Fundamentals — Question 130

Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates. backups, and maintenance tasks?

Answer options

• A. Azure SQL Managed Instance
• B. SQL Server on Azure Virtual Machines
• C. Azure SQL Database
• D. Azure SQL Edge

Correct answer: A

Explanation

Azure SQL Managed Instance is designed to provide near-100 percent compatibility with on-premises SQL Server, making it ideal for migrations while automating updates, backups, and maintenance. The other options, such as SQL Server on Azure Virtual Machines, do not offer this level of integration and automation, as they require more management overhead. Azure SQL Database and Azure SQL Edge also serve different use cases that do not match the compatibility and automation features of Managed Instance.