Microsoft Azure Data Fundamentals — Question 221

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

Answer options

• A. Azure SQL Database
• B. Azure Database for MySQL
• C. Azure SQL Managed Instance
• D. an Azure SQL Database elastic pool

Correct answer: C

Explanation

Azure SQL Managed Instance is specifically designed to provide high compatibility with on-premises SQL Server databases, making it the best choice for migrating from Microsoft SQL Server 2019 Enterprise edition. Azure SQL Database and Azure Database for MySQL do not offer the same level of compatibility, and while an elastic pool is useful for managing multiple databases, it does not inherently provide compatibility features.