ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam
Go to Exam

Exam 70-464 topic 4 question 8 discussion

Actual exam question from Microsoft's 70-464
Question #: 8
Topic #: 4
[All 70-464 Questions]

Developers report that usp_UpdateOffice periodically returns error 3960.
You need to prevent the error from occurring. The solution must ensure that the stored procedure return the original values to all of the updated rows.
What should you configure in StoredProcedures.sql?

  • A. Move the SET statement at line 38 to line 45
  • B. Change line 38 to: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
  • C. Move the SELECT statement at line 41 to line 50
  • D. Change line 38 to: SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by d_m at Jan. 6, 2021, 10:34 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
d_m
4 years, 5 months ago
i don't understand why 'c' is the answer can someone please explain? Thanks
upvoted 1 times
Dolous
4 years, 5 months ago
part of procedures.sql is missing, but I believe solution to solve the problem would be changing isolation level, either to serializable or repeatable, depending on requirements
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel