Microsoft
70-433 · Question #9
You have implemented change tracking on a table named Sales.SalesOrder. You need to determine all columns that have changed since the minimum valid version. Which function should you use?
The correct answer is C. CHANGETABLE with the CHANGES argument. See the full explanation below for the reasoning.
Implement a desktop infrastructure
Question
You have implemented change tracking on a table named Sales.SalesOrder. You need to determine all columns that have changed since the minimum valid version. Which function should you use?
Options
- ACHANGE_TRACKING_CURRENT_VERSION
- BCHANGE_TRACKING_IS_COLUMN_IN_MASK
- CCHANGETABLE with the CHANGES argument
- DCHANGETABLE with the VERSION argument
How the community answered
(45 responses)- A2% (1)
- B7% (3)
- C78% (35)
- D13% (6)
Topics
#CHANGETABLE#change tracking#SQL Server functions#column tracking
Community Discussion
No community discussion yet for this question.