1. Which of the following error is returned for a query for all changes when a parameter that is used to define the query interval is not valid ?
Correct Answer is : An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_
2. Point out the correct statement :
Correct Answer is : The function cdc.fn_cdc_get_all_changes_ returns all changes that occurred for the specified interval
3. The commit time of each transaction with an associated entry in a database change table is available in the table __________
Correct Answer is : cdc.lsn_time_mapping
4. Point out the wrong statement :
Correct Answer is : cdc.lsn_time_mapping applies to SQL Server 2014
5. Which of the following query returns the average latency for the most recent sessions ?
Correct Answer is : SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0