Microsoft
70-451 · Question #105
70-451 Question #105: Real Exam Question with Answer & Explanation
The correct answer is D. a MERGE statement that uses the OUTPUT clause. See the full explanation below for the reasoning.
Question
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?
Options
- ATransactions that have the READ UNCOMMITTED isolation level
- BTransactions that have SERIALIZABLE isolation level
- Ca MERGE statement that uses a READCOMMITTEDLOCK table hint
- Da MERGE statement that uses the OUTPUT clause
Community Discussion
No community discussion yet for this question.