WHICH_OF_THE_FOLLOWING_QUERY_RETURNS_THE_AVERAGE_LATENCY_FOR_THE_MOST_RECENT_SESSIONS_??$

Question

TuteeHUB · Accepted Answer

SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0

TuteeHUB · Answer

SELECT latency FROM sys.dm_cdc_log_audit_sessions WHERE session_id = 0

TuteeHUB · Answer

SELECT latency FROM sys.dm_cdc_log_scan_ WHERE session_id = 0

TuteeHUB · Answer

SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

1.	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» C. SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0

Discussion