Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes

What is a benefit of hosting a database on Azure SQL managed instance (DP-900)

Updated on 11/14/2024

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

There are no comments yet.

Authentication required

You must log in to post a comment.
Log in to like this solution

Log in

Support us!
Subscribe Now

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All" you consent to our use of cookies. Privacy Policy.