Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
Which Azure service provides the highest compatibility for databases (DP-900)
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
A. Azure SQL Database
B. Azure Database for MySQL
C. Azure SQL Managed Instance
D. an Azure SQL Database elastic pool
Solution
Correct answer: C. Azure SQL Managed Instance.
Azure SQL Managed Instance offers near 100% compatibility with the SQL Server database engine, making it an ideal choice for migrating SQL Server databases with minimal changes. It supports many of the features available in SQL Server, including SQL Server Agent, cross-database queries, and more, which are not fully supported in Azure SQL Database or other options.
Category: Identify considerations for relational data on Azure