Database Fundamentals — Question 102

You manage a SQL Server 2008 server that hosts a database named Sales.
Unauthorized modifications 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?

Answer options

• A. Create a DDL trigger with database scope.
• B. Create a DML trigger with database scope.
• C. Create a DML trigger with server scope.
• D. Create a DDL trigger with server scope.

Correct answer: A

Explanation

Creating a DDL trigger with database scope is the correct approach because DDL triggers are specifically designed to track changes to database objects such as tables and views. In contrast, DML triggers focus on data modifications like inserts, updates, and deletes, which would not capture structural changes. Server-scoped triggers would affect all databases on the server, which is unnecessary in this case.