DP-300 · Question #354
You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains an Extended Events session named session1 that captures Microsoft SQL Server events. You need to correlate the…
The correct answer is B. Add a target. To correlate Extended Events session events with Event Tracing for Windows (ETW), an ETW target must be added to the Extended Events session.
Question
Options
- AModify the Set Session Event Filters settings.
- BAdd a target.
- CAdd an action.
- DModify the Specify Session Data Storage settings.
How the community answered
(44 responses)- A7% (3)
- B75% (33)
- C16% (7)
- D2% (1)
Why each option
To correlate Extended Events session events with Event Tracing for Windows (ETW), an ETW target must be added to the Extended Events session.
Modifying event filters would limit which events are captured, not enable correlation with ETW.
Adding an ETW target to an Extended Events session allows the session to send captured events directly to an ETW session, enabling correlation with other ETW events for comprehensive system monitoring and diagnostics.
Adding an action would execute a specific task in response to an event, rather than enabling event correlation with ETW.
Modifying data storage settings changes where the Extended Events session data is saved, not how it correlates with ETW.
Concept tested: SQL Server Extended Events ETW target
Source: https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events-targets?view=sql-server-ver16#etw_target
Community Discussion
No community discussion yet for this question.