Each question is worth one point. Checkbox questions use exact-set scoring: select every correct choice and no others. Partial, extra, duplicate or malformed selections receive no credit for that question. Radio questions accept one choice.
Select all correct answers.
A. Events
B. Actions
C. Predicates and targets
D. A mandatory SQL Server Profiler trace
A. Select only events and context needed for the question
B. Apply a relevant database or duration predicate
C. Configure an event_file target and bounded file growth
D. Capture every event indefinitely because XE has zero overhead
A. STATE = START begins collection for an existing session
B. STATE = STOP stops collection while retaining its definition
C. Stopping always drops the session definition
D. STARTUP_STATE = ON alone starts collection immediately
A. Duration and CPU payload fields where the event provides them
B. Logical-read payload fields where available
C. Supported login/application actions when identity is needed
D. Query Store averages as proof of a particular login
E. Event metadata to confirm field names and units