Exam 70-762 topic 1 question 101 discussion

DRAG DROP -
You need to implement triggers to automate responses to the following events:
✑ SQL Server logons
✑ Database schema changes
✑ Database updates
Which trigger types should you use? To answer, drag the appropriate trigger types to the appropriate scenarios. Each trigger type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Suggested Answer:
Box 1: LOGON -
Logon triggers fire stored procedures in response to a LOGON event. This event is raised when a user session is established with an instance of SQL Server.

Box 2: INSTEAD OF INSERT -
An "INSTEAD of trigger" is executed instead of the original operation, and not combining with the operation. INSTEAD OF triggers override the standard actions of the triggering statement. It can be used to bypass the statement and execute a whole different statement, or just help us check and examine the data before the action is done.

Box 3: DDL -
DDL statements (CREATE or ALTER primarily) issued either by a particular schema/user or by any schema/user in the database
Note:
You can write triggers that fire whenever one of the following operations occurs:
✑ DML statements (INSERT, UPDATE, DELETE) on a particular table or view, issued by any user
✑ DDL statements (CREATE or ALTER primarily) issued either by a particular schema/user or by any schema/user in the database
✑ Database events, such as logon/logoff, errors, or startup/shutdown, also issued either by a particular schema/user or by any schema/user in the database
References:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/triggers.htm https://social.technet.microsoft.com/wiki/contents/articles/28152.t-sql-instead-of-triggers.aspx https://docs.microsoft.com/en-us/sql/relational-databases/triggers/logon-triggers?view=sql-server-2017