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:
Answer: 
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
21
1
I tested it in SQL Server, you are correct. sp_tableoption only need alter permission. ALTER_TABLE and DROP_TABLE are enough in this trigger!
9
0
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
7
1
Also, the answer is incorrect because: CREATE TRIGGER must be the first statement in the batch.
0
3
Yeap, To execute sp_tableoption requires ALTER permission on the table.
SO 1-4-2
11
0