Developing SQL Databases — Question 101

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a database named dbReporting. Users run a large number of read-only ad hoc queries against the database. The application and all ad hoc queries use default database transaction isolation levels. You set the value of the READ_COMMITTED_SNAPSHOT database option to ON.
You have an application that updates 10 tables sequentially and modifies a large volume of records in a single transaction. The updates are isolated from each other.
Users report an error which indicates that the version store us full.
You need to reduce the number of occurrences of the error.
Solution: You increase the maximum database size for the tempdb database.
Does the solution meet the goal?

Answer options

Correct answer: A

Explanation

Increasing the maximum size of the tempdb database can help accommodate the version store requirements created by the READ_COMMITTED_SNAPSHOT option, thus reducing the chances of encountering a full version store error. The other option, 'No', is incorrect because not addressing the size of tempdb would not resolve the version store issue.