Administering a SQL Database Infrastructure — Question 231

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C, as change data capture (CDC) allows you to track changes, including deletions, made to a table with minimal overhead. Configuring table permissions (A) and user roles (B) focuses on access control rather than monitoring changes, while using a trigger (D) may require more development and maintenance than CDC.