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?

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?

Accepted Answer

B. Use a transaction that uses the WITH (NOLOCK) hint.

Answer

A. Set the transaction isolation level to SERIALIZABLE.

Answer

C. Use a transaction that uses the WITH (HOLDLOCK) hint.

Answer

D. Set the transaction isolation level to READ UNCOMMITTED.

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…

Question

Options

How the community answered

Community Discussion