Microsoft Azure Architect Technologies (2020, legacy) — Question 109

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?

Answer options

Correct answer: B

Explanation

The correct answer is B because Azure SQL Database managed instances do not support distributed transactions across multiple databases. Instead, for server-side transactions across DB1 and DB2, a more suitable option would be to use SQL Server on Azure Virtual Machines or Azure SQL Database elastic pools, which can handle such scenarios.