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 ?
A. SELECT latency FROM sys.dm_cdc_log_audit_sessions WHERE session_id = 0
B. SELECT latency FROM sys.dm_cdc_log_scan_ WHERE session_id = 0
C. SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0
D. SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
Answer:A
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 ?
A. SELECT latency FROM sys.dm_cdc_log_audit_sessions WHERE session_id = 0 B. SELECT latency FROM sys.dm_cdc_log_scan_ WHERE session_id = 0 C. SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0 D. SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
Explanation:You can use latency data to determine how fast or slow the capture process is processing transactions. 7. __________ gives DBAs an option to shut down the server in case of an audit log failure.