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?
A.
Set the transaction isolation level to READ UNCOMMITTED.
B.
Set the transaction isolation level to SERIALIZABLE.
C.
Use a transaction that uses the WITH (NOLOCK) hint.
D.
Use a transaction that uses the WITH (HOLDLOCK) hint.