Microsoft
70-459 · Question #25
You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a table that is used for auditing is updated. What should you use? More than one…
Sign in or unlock 70-459 to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
Implement programming objects
Question
You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a table that is used for auditing is updated. What should you use? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- Aa DEFAULT constraint
- Ba Data Definition Language (DDL) trigger
- Ca CHECK constraint
- Da FOREIGN KEY constraint
- Ea data manipulation language (DML) trigger
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#DML trigger#auditing#audit table#INSERT