Microsoft
70-432 · Question #217
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…
The correct answer is D. Set the isolation level to Read Committed Snapshot for the InsightDB database. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the database snapshot feature and configure the application to use the snapshot
- BSet the isolation level to Read Uncommitted for the InsightDB database.
- CUse the database replication feature and configure the application to use the replicated
- DSet the isolation level to Read Committed Snapshot for the InsightDB database.
How the community answered
(18 responses)- A6% (1)
- B17% (3)
- C6% (1)
- D72% (13)
Community Discussion
No community discussion yet for this question.