Question

Which of the following pair of views has one to many relationship?

(a) sys.server_event_session_actions.event_session_id, sys.sys.server_event_sessions.event

(b) sys.server_event_session_actions, sys.sys.server_event_sessions.event_session_id

(c) sys.server_event_session_actions.event_session_id,sys.sys.server_event_sessions.event _session_id

(d) none of the mentioned

This question was addressed to me during an internship interview.

This is a very interesting question from Extended Events in section Monitoring and Auditing of SQL Server

Answer 1

The correct choice is (c) sys.server_event_session_actions.event_session_id,sys.sys.server_event_sessions.event _session_id

Best explanation: Almost all the extended event views has one to many cardinality.