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:
should be D? CDC does not track who made the changes.
It is actually CDC.
SQL Server 2012 provides two features that track changes to data in a database: change data capture and change tracking. These features enable applications to determine the DML changes (insert, update, and delete operations) that were made to user tables in a database. Change data capture and change tracking can be enabled on the same database; no special considerations are required.
Reference:
https://msdn.microsoft.com/en-us/library/bb933994(v=sql.110).aspx
NO IT S NOT CDC , you can’t track who make the changes
The Question is not to log who deleted the information… but to track the deletion itself. Therefore CDC is the correct answer.