Exam 70-762 topic 1 question 58 discussion

Actual exam question from Microsoft's 70-762

Question #: 58
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 that contains a table named Employees. The table stored information about the employees of your company.
You need to implement the following auditing rules for the Employees table:
- Record any changes that are made to the data in the Employees table.
- Customize the data that is recorded by the audit operations.
Solution: You implement a stored procedure on the Employees table.
Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
We should use table-valued functions, not procedures, to customize the recorded change data.
References:
https://msdn.microsoft.com/en-us/library/cc645858.aspx

by kimalto452 at Dec. 23, 2020, 12:35 a.m.