Microsoft
70-459 · Question #47
You need to recommend a solution that addresses the concurrency requirement. What should you recommend?
The correct answer is B. Modify the stored procedures to update tables in the same order for all of the stored. See the full explanation below for the reasoning.
Question
You need to recommend a solution that addresses the concurrency requirement. What should you recommend?
Options
- AMake calls to Sales.Proc1 and Sales.Proc2 synchronously.
- BModify the stored procedures to update tables in the same order for all of the stored
- CCall the stored procedures in a Distributed Transaction Coordinator (DTC) transaction.
- DBreak each stored procedure into two separate procedures, one that changes Sales.Table1
How the community answered
(27 responses)- A15% (4)
- B70% (19)
- C4% (1)
- D11% (3)
Community Discussion
No community discussion yet for this question.