Explanation:If only a subset of columns need to be tracked, such as for privacy or performance reasons, use the @captured_column_list parameter to specify the subset of columns. 6. Which of the following query determine sessions that had an empty scan ?
A. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count <> 0
B. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0
C. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0
D. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0
Answer:A
Explanation:If only a subset of columns need to be tracked, such as for privacy or performance reasons, use the @captured_column_list parameter to specify the subset of columns. 6. Which of the following query determine sessions that had an empty scan ?
A. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count <> 0 B. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0 C. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0 D. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0