What should you recommend?

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.

View Answer

Answer: D

Explanation:

* Concurrency Requirements

You must reduce the likelihood of deadlocks occurring when Sales.Proc1 and Sales.Proc2 execute.