You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?
A . Bind your application with ISOLATION(UR)
B . Bind your application with ISOLATION(CS)
C . Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
D . Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)
Answer: D
Latest C2090-320 Dumps Valid Version with 123 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund