nerdexam
Microsoft

AZ-204 · Question #45

Drag and Drop Question You are developing a multi-tenant ASP.NET Core application that will be hosted on Azure. The application will support multiple database platforms, including Azure SQL and…

The correct answer is Elastic Database Client Library; MSDTC. The Elastic Database Client Library is the correct choice for distributed transactions across Azure SQL databases in a multi-tenant cloud scenario, as it provides elastic transactions that span multiple Azure SQL Database instances without requiring MSDTC. MSDTC (Microsoft…

Submitted by ricky.ec· Mar 30, 2026Develop Azure compute solutions – implementing distributed data solutions and transaction management across cloud and on-premises environments in ASP.NET Core applications

Question

Drag and Drop Question You are developing a multi-tenant ASP.NET Core application that will be hosted on Azure. The application will support multiple database platforms, including Azure SQL and on-premises SQL Server instances. You need to ensure the application supports distributed transactions. Which technologies should you use? To answer, drag the appropriate technologies to the correct scenarios. Each technology may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibit

AZ-204 question #45 exhibit

Answer Area

Drag items

Elastic Database Client LibrarySQLiteMSDTCSQLCMD

Correct arrangement

  • Elastic Database Client Library
  • MSDTC

Explanation

The Elastic Database Client Library is the correct choice for distributed transactions across Azure SQL databases in a multi-tenant cloud scenario, as it provides elastic transactions that span multiple Azure SQL Database instances without requiring MSDTC. MSDTC (Microsoft Distributed Transaction Coordinator) is the correct choice for on-premises SQL Server instances, as it is the traditional Windows service that coordinates distributed transactions across multiple resource managers in on-premises environments. Together, these two technologies cover both the cloud (Azure SQL) and on-premises (SQL Server) distributed transaction scenarios described in the question.

Topics

#Distributed Transactions#Azure SQL#Elastic Database Client Library#MSDTC

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-204 Practice