Question

_________ returns a row for each customizable column that was explicitly set on events and targets.

(a) sys.server_event_session_targets

(b) sys.server_event_session_fields

(c) Returns a row for each event in an event session

(d) All of the mentioned

I have been asked this question in examination.

I would like to ask this question from Extended Events in portion Monitoring and Auditing of SQL Server

Answer 1

Right option is (b) sys.server_event_session_fields

Best explanation: sys.server_event_session_fields requires VIEW SERVER STATE permission on the server.