What should you recommend?

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.

View Answer

Answer: C