You are designing a Windows Azure application that will store data in two SQL Azure databases. The
application will insert data in both databases as part of a single logical operation. You need to recommend an
approach for maintaining data consistency across the databases.
What should you recommend?
A.
Execute database calls on parallel threads.
B.
Wrap the database calls in a single transaction scope.
C.
Use Microsoft Distributed Transaction Coordinator (MSDTC).
D.
Handle errors resulting from the database calls by using compensatory logic.
If the application runs on a IaaS VM (which is not specified), the above answer can be correct:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-transactions-overview
“On premises, such a scenario usually required running Microsoft Distributed Transaction Coordinator (MSDTC). Since MSDTC is not available for Platform-as-a-Service application in Azure, the ability to coordinate distributed transactions has now been directly integrated into SQL DB”
0
0
This question and the one before that does not seem to be 70-533 related.
0
1
Agreed.
0
0
Option B is right answer. MSDTC is not supported and wrapping code in a transaction scope is the new option in SQL Azure. Please refer section:”Multi-database applications” from below link:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-transactions-overview
0
1