Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
What is a benefit of hosting a database on Azure SQL managed instance (DP-900)
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
A. built-in high availability
B. native support for cross-database queries and transactions
C. system-initiated automatic backups
D. support for encryption at rest
Solution
Correct answer: B. native support for cross-database queries and transactions.
Azure SQL Managed Instance provides native support for cross-database queries and transactions, which allows for more flexibility and ease of use when working with multiple databases. This feature is not available in Azure SQL Database, where cross-database queries and transactions are more complex to implement.
Azure SQL Managed Instance is designed to provide a more comprehensive set of features, similar to those found in on-premises SQL Server, including support for cross-database queries and transactions.
Here's why the other options are not the best fit:
A. Both Azure SQL Database and Azure SQL Managed Instance provide built-in high availability.
C. Both Azure SQL Database and Azure SQL Managed Instance provide system-initiated automatic backups.
D. Both Azure SQL Database and Azure SQL Managed Instance support encryption at rest.
While all these features are important, they are not unique benefits of Azure SQL Managed Instance compared to Azure SQL Database.
Category: Identify considerations for relational data on Azure