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 minimiz

The correct answer is A. Change data capture. Change data capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. The change tables used by change data capture contain columns that mirror the col

Submitted by viktor_hu· Mar 5, 2026Design and implement database solutions for SQL Server

Question

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?

Options

AChange data capture
BStatistics
CA trigger
DMaster Data Services

How the community answered

(63 responses)

A
95% (60)
B
3% (2)
C
2% (1)

Explanation

Change data capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. The change tables used by change data capture contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred.

Topics

#change data capture#data auditing#data tracking

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice