DRAG DROP
You have a trigger named CheckTriggerCreation that runs when a user attempts to create a trigger. The
CheckTriggerCreation trigger was created with the ENCRYPTION option and additional proprietary business
logic.
You need to prevent users from running the ALTER and DROP statements or the sp_tableoption stored
procedure.
Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate
Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the
correct order.
Select and Place:
Which three Transact-SQL segments should you use to dev…
DRAG DROP
You have a trigger named CheckTriggerCreation that runs when a user attempts to create a trigger. The
CheckTriggerCreation trigger was created with the ENCRYPTION option and additional proprietary business
logic.
You need to prevent users from running the ALTER and DROP statements or the sp_tableoption stored
procedure.
Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate
Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the
correct order.
Select and Place:
Wrong answer, DDL_TABLE_EVENTS includes CREATE, Has to be DROP and ALTER Only.
https://docs.microsoft.com/en-us/sql/relational-databases/triggers/ddl-triggers
If required “You need to prevent users from running the ALTER and DROP statements or the sp_tableoption stored procedure.” then
Answer: 1-4-2
Verify link: https://docs.microsoft.com/en-us/sql/relational-databases/triggers/ddl-triggers