Administering a SQL Database Infrastructure — Question 141

You deploy a database by using SQL Server 2014.
The database contains a table named Table1.
You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount of custom code required.
What should you recommend?

Answer options

• A. Change data capture
• B. Statistics
• C. A trigger
• D. Master Data Services

Correct answer: A

Explanation

Change data capture (CDC) is specifically designed to track changes in SQL Server databases with minimal custom code, making it the best option for monitoring deletions. Statistics, triggers, and Master Data Services do not provide the same level of built-in support for tracking deletions without significant additional coding or configuration.