What should you configure?

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.

View Answer

Answer: C