Developing SQL Databases — Question 133
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 dbReporting database.
Does the solution meet the goal?
Answer options
- A. Yes
- B. No
Correct answer: B
Explanation
The proposed solution does not address the issue of the version store being full, which is primarily related to the management of row versions in memory rather than the physical size of the database. Increasing the database size will not prevent the version store from filling up quickly due to the large volume of updates occurring in a single transaction. Thus, the correct answer is B, as the solution fails to meet the goal of reducing the occurrence of the error.