Explanation:Change tracking is used to enable applications to query for changes to data in a database and access information that is related to the changes, application developers had to implement custom change tracking mechanisms. 3. Which of the following is biggest disadvantage of change tracking ?
A. Schema changes are required in the server database
B. Triggers are fired for each change that has been made to a row
C. Logic for maintaining the correct row versions and deletions is easy
D. All of the mentioned
Answer:A
Explanation:Change tracking is used to enable applications to query for changes to data in a database and access information that is related to the changes, application developers had to implement custom change tracking mechanisms. 3. Which of the following is biggest disadvantage of change tracking ?
A. Schema changes are required in the server database B. Triggers are fired for each change that has been made to a row C. Logic for maintaining the correct row versions and deletions is easy D. All of the mentioned
Explanation:Triggers for each change has performance implications. 4. Which of the following query selects incremental inserts from the Sales.Customer table at the server ?