Exam AZ-302 topic 6 question 13 discussion

Actual exam question from Microsoft's AZ-302

Question #: 13
Topic #: 6

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.

Show Suggested Answer

Suggested Answer: BD 🗳️
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-transactions-overview#transactions-across-multiple-servers

by [deleted] at April 4, 2025, 9:30 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!