nerdexam
Microsoft

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.

Submitted by paula_co· Mar 6, 2026Design infrastructure solutions

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. Your company currently has an application that is hosted on their on-premises environment. The application currently connects to two databases in the on-premises environment. The databases are named whizlabdb1 and whizlabdb2. You have to move the databases onto Azure. The databases have to support server-side transactions across both of the databases. Solution: You decide to deploy the databases to an Azure SQL database-managed instance. Would this fulfill the requirement?

Options

  • AYes
  • BNo

How the community answered

(28 responses)
  • A
    79% (22)
  • B
    21% (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.

AYesCorrect

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.

BNo

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.

Full AZ-305 Practice