Microsoft
98-364 · Question #112
98-364 Question #112: Real Exam Question with Answer & Explanation
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.
Community Discussion
No community discussion yet for this question.