Microsoft Azure Data Fundamentals — Question 301

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Answer options

• 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

Correct answer: B

Explanation

The correct answer is B because Azure SQL managed instance provides native support for cross-database queries and transactions, which is not available in Azure SQL database. Options A, C, and D are features that both services share, meaning they do not represent a unique advantage of the managed instance over the standard database.