Question 690
A database captures a record of critical status changes, including changes made outside the primary application. The team is considering this step: Add a set-based trigger with narrow immutable audit writes only if approved. What evidence should they review before proceeding?
Explanation
Correct Answer
Check multi-row statements, recursion, transaction cost and audit requirements. A DML trigger can react to supported table changes using inserted/deleted virtual tables. 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 pertinent evidence includes: Check multi-row statements, recursion, transaction cost and audit requirements.