Exam 70-762 topic 1 question 20 discussion

Actual exam question from Microsoft's 70-762

Question #: 20
Topic #: 1

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?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️
References:
https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-2017

by bobby007 at May 11, 2020, 11:06 a.m.

Comments

Submit Cancel

delgadillo

Highly Voted 4 years, 11 months ago

Answer is Yes

upvoted 17 times

...

Mosufe

Highly Voted 4 years, 9 months ago

The answer is Yes. "You need to reduce the number of occurrences of the error." They dont want to eliminate the problem, just REDUCE the problem.

upvoted 7 times

...

bobby007

Most Recent 5 years, 1 month ago

Answer is no

upvoted 3 times

amar111

5 years ago

any reason for no ? because row versions are store in tempdb . And increasing the space of Tempdb , will definitely reduce the frequency of error occuerence

upvoted 12 times

delgadillo

4 years, 11 months ago

yes, the correct answers is A

upvoted 8 times

...