Exam 98-364 topic 1 question 201 discussion

Actual exam question from Microsoft's 98-364

Question #: 201
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by Buzzardonic at July 14, 2021, 7:39 a.m.

Comments

Submit Cancel

wheredajuice

3 years, 10 months ago

No it's DDL, because when you modify a table so that some views cease to work, you have used DDL to modify that table. If you just used DML to modify data in the table, the views would still work.

upvoted 1 times

...

Buzzardonic

3 years, 10 months ago

Surely the answer is B, as you would be logging the modification to a separate table using DML? Or is the question asking which of DDL and DML you would use to create the trigger?

upvoted 1 times

...