Explanation:Change tracking is used for one way and two way synchronization applications. 6. Which of the following code snippet returns a version integer that is associated with the last committed transaction that was tracked by change tracking ?
A. SELECT @sync_new_received_anchor = change_tracking_cur_version()
B. SELECT @sync_new_received_anchor = change_tracking_current_ver()
C. SELECT @sync_new_received_anchor = change_tracking_current_version()
D. SELECT @sync_new_received_anchor = change_track_current_version()
Answer:A
Explanation:Change tracking is used for one way and two way synchronization applications. 6. Which of the following code snippet returns a version integer that is associated with the last committed transaction that was tracked by change tracking ?
A. SELECT @sync_new_received_anchor = change_tracking_cur_version() B. SELECT @sync_new_received_anchor = change_tracking_current_ver() C. SELECT @sync_new_received_anchor = change_tracking_current_version() D. SELECT @sync_new_received_anchor = change_track_current_version()
Explanation:The integer value is stored in the client database and is used by the commands that synchronize changes. 7. Valid Syntax for WITH CHANGE_TRACKING_CONTEXT is :