Developing SQL Databases — Question 140
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 auto growth rate for the dbReporting database.
Does the solution meet the goal?
Answer options
- A. Yes
- B. No
Correct answer: B
Explanation
The correct answer is B because increasing the auto growth rate does not address the issue of the version store filling up, which is related to the management of row versioning in the context of the READ_COMMITTED_SNAPSHOT setting. The error is caused by the large volume of modifications in a single transaction, and simply increasing the database's growth rate will not resolve this underlying problem.