Exam DP-800 Topic 1 Question 97 Discussion

Actual exam question for Microsoft's DP-800 exam
Question #: 97
Topic #: 1
You have an Azure SQL database That contains database-level Data Definition Language (DDL) triggers, including a trigger named ddl_Audit.
You need to prevent ddl_Audit from firing during the next deployment. The trigger object must remain in place.
Which Transact-SQL statement should you use?

Suggested Answer: D Vote an answer

The requirement is very specific: prevent ddl_Audit from firing during the next deployment , but leave the trigger object in place . Microsoft documents DISABLE TRIGGER as the statement used to disable a trigger without dropping it. That is exactly the right operation for a temporary suspension of a DDL trigger.
For a database-scoped DDL trigger, the syntax is on the database scope, for example DISABLE TRIGGER ddl_Audit ON DATABASE;.
The other options do not meet the requirement as directly:
* ALTER TRIGGER changes the trigger definition, not simply disables execution.
* ALTER DATABASE is not the direct statement for disabling a specific DDL trigger.
* ALTER SERVER AUDIT SPECIFICATION and ALTER DATABASE AUDIT
SPECIFICATION are audit-feature statements, not trigger-control statements.
So the correct Transact-SQL statement is DISABLE TRIGGER .

by Roderick at Jun 30, 2026, 09:38 AM

Limited Time Offer

15%

Off

Get Premium DP-800 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10