SQL Server Questions and Answers – Extended Events

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Extended Events”.

1. Which of the following is an extended event task?
a) create an Extended Events session
b) alter an Extended Events session
c) find out what events are available in the registered packages
d) all of the mentioned
View Answer

Answer: d
Explanation: Using Management Studio or Transact-SQL to execute Transact-SQL Data Definition Language statements, dynamic management views and functions, or catalog views, you can create simple or complex SQL Server Extended Events troubleshooting solutions for your SQL Server environment.

2. Point out the correct statement.
a) The SQL Server Extended Events engine is a collection of services and objects
b) Buffers are attached to sessions to handle buffering and dispatch, and causality tracking
c) Policy tracking provides the ability to track work across multiple tasks
d) None of the mentioned
View Answer

Answer: a
Explanation: The Extended Events engine itself does not provide any events or actions to take when an event fires.

3. SQL Server Extended Events Packages consist of _____________
a) Events
b) Predicates
c) Types
d) All of the mentioned
View Answer

Answer: d
Explanation: Packages are identified by a name, a GUID, and the binary module that contains the package.

4. Which of the DDL statement creates a session object that contains the metadata?
a) CREATE EVENT SESSION
b) CREATE SESSION
c) CREATE EVENT SESSION METADATA
d) None of the mentioned
View Answer

Answer: a
Explanation: CREATE EVENT SESSION creates an Extended Events session that identifies the source of the events, the event session targets, and the event session options.

advertisement
advertisement

5. Point out the wrong statement.
a) Actions and predicates are bound to events on a per-session basis
b) Extended Event sessions have implied boundaries in that the configuration of one session does change the configuration of another session
c) The mapping between package objects and sessions is many to many
d) None of the mentioned
View Answer

Answer: b
Explanation: Boundaries do not prevent an event or target from being used in more than one session.

6. _________ can be applied to the metadata or to an active session and the metadata.
a) DROP EVENT SESSION
b) ALTER EVENT SESSION,STATE=STOP
c) ALTER EVENT SESSION,STATE=START
d) All of the mentioned
View Answer

Answer: d
Explanation: Both ALTER EVENT SESSION and DROP EVENT SESSION can be applied to the metadata or to an active session and the metadata.

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

7. Which of the following catalog view is used for SQL Server Extended Events?
a) sys.server_sessions
b) sys.server_event_sess
c) sys.server_event_session_actions
d) all of the mentioned
View Answer

Answer: c
Explanation: sys.server_event_session_actions returns a row for each action on each event of an event session.

8. _________ 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
View Answer

Answer: b
Explanation: sys.server_event_session_fields requires VIEW SERVER STATE permission on the server.

advertisement

9. 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
View Answer

Answer: c
Explanation: Almost all the extended event views has one to many cardinality.

10. Which of the following format output events in an Event Tracing for Windows?
a) event_file
b) ring_buffer
c) histogram
d) etw_classic_sync_target
View Answer

Answer: d
Explanation: histogram outputs events to memory in order to group and count events based on fields or actions.

advertisement

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.