You administer a SQL Server 2008 instance that contains a database named InsightDB.
The InsightDB database is used by an application that is continuously connected.
The application uses the INSERT command extensively. The application uses triggers to
populate multiple tables.
You need to ensure that the reports generated by the application using the InsightDB
database return current information with minimal negative effects on the application inserts.
What should you do?
A.
Use the database snapshot feature and configure the application to use the snapshot
database.
B.
Set the isolation level to Read Uncommitted for the InsightDB database.
C.
Use the database replication feature and configure the application to use the replicated
database.
D.
Set the isolation level to Read Committed Snapshot for the InsightDB database.