Question 680
A database captures a record of critical status changes, including changes made outside the primary application. Which implementation step most directly addresses this requirement?
Explanation
Correct Answer
A DML trigger can react to supported table changes using inserted/deleted virtual tables. Add a set-based trigger with narrow immutable audit writes only if approved. One multirow update creates accurate audit entries with no missing affected row.
Incorrect Answers
DML triggers fire per statement; set-based joins over inserted/deleted are required.
Compare actual inserted/deleted values, including NULL and multirow cases.
Keep trigger logic narrow, set-based and transaction-safe; send external work asynchronously. The appropriate case-specific action is: Add a set-based trigger with narrow immutable audit writes only if approved.