Explanation:The SQL Server data collector lets you collect snapshots of data from any table or dynamic management view and build a performance data warehouse. 5. Point out the wrong statement :
A. cdc.lsn_time_mapping applies to SQL Server 2014.
B. Datetime wrappers are owned by the user, and not are created in the default schema of the caller
C. Change data capture supports up to two capture instances for a single tracked source table
D. The name of the function to wrap the all changes query is fn_all_changes_ followed by the capture instance name.
Answer:A
Explanation:The SQL Server data collector lets you collect snapshots of data from any table or dynamic management view and build a performance data warehouse. 5. Point out the wrong statement :
A. cdc.lsn_time_mapping applies to SQL Server 2014. B. Datetime wrappers are owned by the user, and not are created in the default schema of the caller C. Change data capture supports up to two capture instances for a single tracked source table D. The name of the function to wrap the all changes query is fn_all_changes_ followed by the capture instance name.
Explanation:cdc.lsn_time_mapping applies to: SQL Server (SQL Server 2008 through current version). 6. Which of the following query returns the average latency for the most recent sessions ?