Microsoft
70-432 · Question #217
70-432 Question #217: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #217. The question stem and answer options stay visible for context.
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.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.