Exam 70-464 topic 1 question 11 discussion

Actual exam question from Microsoft's 70-464

Question #: 11
Topic #: 1

You have a Microsoft SQL Azure database.
You have the following stored procedure:

You discover that the stored procedure periodically fails to update HR.Employees.
You need to ensure that HR.Employees is always updated when up_employees executes.
The solution must minimize the amount of time required for the stored procedure to execute and the number of locks held.
What should you do?

A. Add the following line of code to line 05: SET TRANSACTION ISOLATION LEVEL SNAPSHOT
B. Add the following line of code to line 13: WITH (UPDLOCK)
C. Add the following line of code to line 05: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
D. Add the following line of code to line 08: WITH (UPDLOCK)

Show Suggested Answer

Suggested Answer: D 🗳️

by Kepty at Nov. 17, 2020, 9:34 p.m.

Comments

Submit Cancel

Kuratko

4 years, 4 months ago

please correct me: A. line 05: SET TRANSACTION ISOLATION LEVEL SNAPSHOT - will not work as expected B. line 13: WITH (UPDLOCK) - bad line & no sense D. Add the following line of code to line 08: WITH (UPDLOCK) - usually good, but require explicit transaction C. line 05: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE seems to minimalize the amount of the locks? C seems better.

upvoted 2 times

...

Kepty

4 years, 5 months ago

It's OK

upvoted 3 times

...

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam

Exam 70-464 topic 1 question 11 discussion

Comments

Kuratko

Kepty

SY0-701