You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures that will
read data from the database. The stored procedures will be named ABCSPA and ABCSPB.
ABCSPA should be allow dirty reads and ABCSPB should be configured to place range locks on
the data to guarantee read reliability.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)
A.
You should consider configuring ABCSPA with the READ UNCOMMITTED isolation level.
B.
You should consider configuring ABCSPB with the READ UNCOMMITTED isolation level.
C.
You should consider configuring ABCSPA with the SERIALIZABLE isolation level.
D.
You should consider configuring ABCSPB with the SERIALIZABLE isolation level.
Explanation:
http://technet.microsoft.com/en-us/library/ms173763.aspx