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.