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.
Right