What should you do?
A. Modify the report queries to use the UNION statement to combine the results of two or more queries.
B. Update the transaction level of the report query session to READPAST.
C. Update the transaction level of the report query session to READ UNCOMMITTED.
D. Set the READ_COMMITTED_SNAPSHOT database option to ON.
Answer:D
What should you do?
A. Modify the report queries to use the UNION statement to combine the results of two or more queries. B. Update the transaction level of the report query session to READPAST. C. Update the transaction level of the report query session to READ UNCOMMITTED. D. Set the READ_COMMITTED_SNAPSHOT database option to ON.
Explanation: Explanation