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.
B is not an answer. Here is why:
According to the following link:
http://social.technet.microsoft.com/wiki/contents/articles/1639.handling-transactions-in-windows-azure-sql-database.aspx
“So the question is when is it safe to use the TransactionScope class with SQL Database? The simple answer is whenever you use it in a way that the Transaction Manager does not promote the transaction to a distributed transaction.”
Scratch C:
MSDTC DOES NOT WORK WITH SQL AZURE.
What a stupid f’in question – like any of this was in the 70-533 study book. Don’t know the answer. Typical MS bullsh*t question
i think they moved this to the 532 test, but i’m unsure. i see this on the 533 PRACTICE tests, but did not see on the actual 533 test.
Anyway the 583 test [which is what this question is for] was retired…can’t even take it anymore
Errrrrrr! Found it……ANSWER IS B. USING TRANSACTION SCOPE. https://social.technet.microsoft.com/wiki/contents/articles/1639.handling-transactions-in-windows-azure-sql-database.aspx