Microsoft
70-451 · Question #11
You are using Microsoft SQL Server 2008 Enterprise Edition. You need to maintain a history of all data modifications made to a table, including the type of modification and the values modified…
The correct answer is D. Change Data Capture. See the full explanation below for the reasoning.
Question
You are using Microsoft SQL Server 2008 Enterprise Edition. You need to maintain a history of all data modifications made to a table, including the type of modification and the values modified. Which tracking method should you use?
Options
- ADatabase Audit
- BChange Tracking
- CC2 Audit Tracing
- DChange Data Capture
How the community answered
(25 responses)- A12% (3)
- B8% (2)
- C4% (1)
- D76% (19)
Community Discussion
No community discussion yet for this question.