You are developing an app that references data which is sharded across multiple Azure SQL databases.
The app must guarantee transactional consistency for changes across several different sharding key values.
You need to manage the transactions.
What should you implement?

A. Elastic database transactions with horizontal partitioning.

B. Distributed transactions coordinated by Microsoft Distributed Transaction Coordinator (MSDTC).

C. Server-coordinated transactions from .NET application.

D. Elastic database transactions with vertical partitioning.








 

Suggested Answer: A

References:
https://docs.microsoft.com/mt-mt/azure/sql-database/sql-database-elastic-transactions-overview?view=azurermps-6.13.0

This question is in AZ-300 Microsoft Azure Architect Technologies Exam
For getting Microsoft Certified: Azure Solutions Architect Expert Certificate




Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.