Exam 70-762 topic 1 question 73 discussion

Actual exam question from Microsoft's 70-762

Question #: 73
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 are developing a new application that uses a stored procedure. The stored procedure inserts thousands of records as a single batch into the Employees table.
Users report that the application response time has worsened since the stored procedure was updated. You examine disk-related performance counters for the
Microsoft SQL Server instance and observe several high values that include a disk performance issue. You examine wait statistics and observe an unusually high
WRITELOG value.
You need to improve the application response time.
Solution: You replace the stored procedure with a user-defined function.
Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://msdn.microsoft.com/en-us/library/ms345075.aspx

by SoupDJ at Oct. 30, 2020, 5:44 p.m.

Comments

Submit Cancel

SoupDJ

Highly Voted 4 years, 7 months ago

UDF cannot write to a table - and that is what the original stored proc does. Vote for NO.

upvoted 5 times

...