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 wh
ether the solution meets the stated goals.
You have a database that contains a table named Employees. The table stores 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 recorded by the audit operations.
Solution: You implement a user-defined function on the Employees table.
Does the solution meet the goal?
A. Yes
B. No
Explanation:
SQL Server 2016 provides two features that track changes to data in a database: change data capture and change tracking. These features enable applications to determine the DML changes (insert, update, and delete operations) that were made to user tables
in a database.
Change data is made available to change data capture consumers through table-valued functions (TVFs).
References: https://msdn.microsoft.com/en-us/library/cc645858.aspx
B
1
2
B
1
1