AZ-305 · Question #220
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…
The correct answer is A. Yes. Moving two on-premises databases to Azure can maintain support for server-side transactions across both databases if an appropriate Azure SQL offering, such as Azure SQL Managed Instance, is utilized.
Question
Options
- AYes
- BNo
How the community answered
(28 responses)- A79% (22)
- B21% (6)
Why each option
Moving two on-premises databases to Azure can maintain support for server-side transactions across both databases if an appropriate Azure SQL offering, such as Azure SQL Managed Instance, is utilized.
Azure SQL Managed Instance supports distributed transactions across multiple databases via Microsoft Distributed Transaction Coordinator (MSDTC), allowing server-side transactions to span across whizlabdb1 and whizlabdb2 if they are both hosted as part of the managed instance or on separate managed instances with appropriate networking.
Not applicable, as a solution exists that meets the requirements.
Concept tested: Azure SQL Distributed Transactions (MSDTC)
Source: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/distributed-transactions-overview?view=azuresql
Community Discussion
No community discussion yet for this question.