Microsoft
98-364 · Question #112
You manage a SQL Server 2008 server that hosts a database named Sales. Unauthorized odifications to some tables within the Sales database have resulted in some views no longer working. You need to…
The correct answer is A. Create a DDL trigger with database scope. See the full explanation below for the reasoning.
Question
You manage a SQL Server 2008 server that hosts a database named Sales. Unauthorized odifications to some tables within the Sales database have resulted in some views no longer working. You need to implement a method that will ensure that all modifications to any objects with the Sales database are logged. What should you do?
Options
- ACreate a DDL trigger with database scope.
- BCreate a DML trigger with database scope.
- CCreate a DML trigger with server scope.
- DCreate a DDL trigger with server scope.
How the community answered
(44 responses)- A75% (33)
- B2% (1)
- C14% (6)
- D9% (4)
Community Discussion
No community discussion yet for this question.