gs gs116 Monitoring and Auditing - Extended Events - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Monitoring and Auditing. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following is an extended event task?
create an Extended Events session
alter an Extended Events session
find out what events are available in the registered packages
all of the mentioned
Question 2: Point out the correct statement.
The SQL Server Extended Events engine is a collection of services and objects
Buffers are attached to sessions to handle buffering and dispatch, and causality tracking
Policy tracking provides the ability to track work across multiple tasks
None of the mentioned
Question 3: SQL Server Extended Events Packages consist of _____________
Events
Predicates
Types
All of the mentioned
Question 4: Which of the DDL statement creates a session object that contains the metadata?
CREATE EVENT SESSION
CREATE SESSION
CREATE EVENT SESSION METADATA
None of the mentioned
Question 5: Point out the wrong statement.
Actions and predicates are bound to events on a per-session basis
Extended Event sessions have implied boundaries in that the configuration of one session does change the configuration of another session
The mapping between package objects and sessions is many to many
None of the mentioned
Question 6: _________ can be applied to the metadata or to an active session and the metadata.
DROP EVENT SESSION
ALTER EVENT SESSION,STATE=STOP
ALTER EVENT SESSION,STATE=START
All of the mentioned
Question 7: Which of the following catalog view is used for SQL Server Extended Events?
sys.server_sessions
sys.server_event_sess
sys.server_event_session_actions
all of the mentioned
Question 8: _________ returns a row for each customizable column that was explicitly set on events and targets.
sys.server_event_session_targets
sys.server_event_session_fields
Returns a row for each event in an event session
All of the mentioned
Question 9: Which of the following pair of views has one to many relationship?
sys.server_event_session_actions.event_session_id, sys.sys.server_event_sessions.event
sys.server_event_session_actions, sys.sys.server_event_sessions.event_session_id
sys.server_event_session_actions.event_session_id,sys.sys.server_event_sessions.event _session_id
none of the mentioned
Question 10: Which of the following format output events in an Event Tracing for Windows?
event_file
ring_buffer
histogram
etw_classic_sync_target
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
