Microsoft Exam 70-464 Topic 10 Question 5 Discussion

Actual exam question for Microsoft's 70-464 exam

Question #: 5
Topic #: 10

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?

AAdd the following line of code to line 05:

BAdd the following line of code to line 13:

CAdd the following line of code to line 05:

DAdd the following line of code to line 08:

Show Suggested Answer

Suggested Answer: D

by Levi at May 06, 2022, 03:58 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!