Azure SQL Database Managed Instance
Question
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an app named App1 that uses data from two on-premises Microsoft SQL Server databases named DB1 and DB2.
You plan to move DB1 and DB2 to Azure.
You need to implement Azure services to host DB1 and DB2. The solution must support server-side transactions across DB1 and DB2.
Solution: You deploy DB1 and DB2 to an Azure SQL Database managed instance.
Does this meet the goal?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B.B
Instead deploy DB1 and DB2 to SQL Server on an Azure virtual machine.
Note: Understanding distributed transactions.
When both the database management system and client are under the same ownership (e.g. when SQL Server is deployed to a virtual machine), transactions are available and the lock duration can be controlled.
https://docs.particular.net/nservicebus/azure/understanding-transactionality-in-azureYes, the solution of deploying DB1 and DB2 to an Azure SQL Database managed instance meets the goal of supporting server-side transactions across DB1 and DB2.
Azure SQL Database Managed Instance is a fully-managed database service that provides a platform for migrating SQL Server databases to the cloud. It supports server-side transactions across multiple databases, including both on-premises and Azure-hosted databases. By deploying DB1 and DB2 to an Azure SQL Database managed instance, you can achieve high availability, disaster recovery, and scalability benefits of the cloud while still maintaining the same level of transactional consistency and data integrity as an on-premises SQL Server deployment.
With Azure SQL Database Managed Instance, you can use transactional replication or distributed transactions to enable server-side transactions across multiple databases. Transactional replication can be used to replicate changes between two or more databases, while distributed transactions can be used to execute a transaction across multiple databases in a single atomic unit of work.
In summary, deploying DB1 and DB2 to an Azure SQL Database managed instance is a suitable solution for hosting the databases in Azure while still supporting server-side transactions across both databases.
