Microsoft
70-451 · Question #66
70-451 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Question
A new data analytics application is being implemented in your organization. Users will run a process that compares result sets before and after executing complex data modifications. The data will always be queried by using the same conditions. Some tables updated by the processes will not need to be compared. Your need to design a locking strategy for the process that meets the following requirements: - Enables other processes or users to modify tables that are not being compared - Prevents other processes from performing data manipulation language (DML) activity on the tables that are being compared What should the strategy include?
Options
- ASet the transaction isolation level to SERIALIZABLE.
- BUse a transaction that uses the WITH (NOLOCK) hint.
- CUse a transaction that uses the WITH (HOLDLOCK) hint.
- DSet the transaction isolation level to READ UNCOMMITTED.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.