You have production tables that are based on data from staging tables. You plan to create
stored procedures that will perform the following actions on the production tables: • Insert
new rows • Update existing rows • Ignore duplicate rows • Maintain data integrity • Create
an audit trail of all operations You need to develop a strategy for the planned stored
procedures to minimize locking operations. The solution must be developed by using use
the minimum amount of effort. What should you use?
A.
a MERGE statement that uses a READCOMMITTEDLOCK table hint
B.
Transactions that have SERIALIZABLE isolation level
C.
Transactions that have the READ UNCOMMITTED isolation level
D.
a MERGE statement that uses the OUTPUT clause
Explanation: