You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. You have a database named CorpDB. CorpDB contains a table named
SalesInfo. You discover that some table has been deleted from the SalesInfo table. You are unable to find out
who deleted the information. You need to implement a solution to monitor the deletion of any further information
from the SalesInfo table. You want to minimize the development effort required for the solution. What should
you configure?
A.
You should configure table permissions.
B.
You should configure a user role.
C.
You should configure change data capture.
D.
You should configure a trigger.
CDC won’t provide you with the required information without altering original or CDC table. Neither would a trigger work without additional columns or tables but it would be a cleaner solution.
“You need to implement a solution to monitor the deletion of any further information from the SalesInfo table.”
The question is crappy but its not about monitoring the user. Its only about getting the data changes. So I think CDC is the right answer.