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. The CorpDB database contains a table named
SalesInfo.
You discover that some information 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.
Explanation: