You develop a payment processing solution by using a .NET Framework application.
Customer data is spread across multiple Azure SQL Database servers and is not sharded. When a payment is made from one person to another person, data may be changed in multiple databases at once.
You need to ensure transactional atomicity across databases.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. In the solution, use the OpenConnectionForKey function to reference each database that will be included during a distributed transaction.
B. In Azure PowerShell, create a new communication relationship between each database that requires distributed transactions.
C. Use the Microsoft Distributed Transaction Coordination (MS DTC) service to configure distributed transactions between each database.
D. In the solution, create new SqlConnection objects for each database that will be included during a distributed transaction.
