AZ-204 Question #45: Real Exam Question with Answer & Explanation

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:

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.

No community discussion yet for this question.