You need to recommend a solution that addresses the concurrency requirement.
What should you recommend?
A . Break each stored procedure into two separate procedures, one that changes Sales.Table1 and one that changes Sales.Table2.
B . Make calls to Sales.Proc1 and Sales.Proc2 synchronously.
C . Call the stored procedures in a Distributed Transaction Coordinator (DTC) transaction.
D . Modify the stored procedures to update tables in the same order for all of the stored procedures.
Answer: D
Explanation:
* Concurrency Requirements
You must reduce the likelihood of deadlocks occurring when Sales.Proc1 and Sales.Proc2 execute.