Exit 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Question 2 of 5
0% complete
Q2 Single choice

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:

What should the strategy include?

  • A

    Set the transaction isolation level to SERIALIZABLE.

  • B

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

  • C

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

  • D

    Set the transaction isolation level to READ UNCOMMITTED.

Previous Next