How to Correlate Extended Events with ETW in Azure SQL VM?

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 session events with events captured by Event Tracing for Windows (ETW). What should you do for session1?

  1. Modify the Set Session Event Filters settings.
  2. Add a target. Source Reference Answer
  3. Add an action.
  4. Modify the Specify Session Data Storage settings.

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The exam tests your knowledge of Extended Events targets; the common trap is confusing targets with actions or filters when the goal is output correlation with ETW.

To correlate Extended Events with Event Tracing for Windows (ETW) on an Azure SQL VM, you must add the ETW target to the session. Community consensus confirms this is achieved by adding the etw_classic_sync_target.

Option A (Modify the Set Session Event Filters settings) is commonly chosen by those who confuse filtering captured events with directing event output to an external consumer like ETW.

Community Discussion (3 comments)

voodoo_sh 👍 1
B. Add a target To correlate the events captured by your Extended Events session (session1) with events captured by Event Tracing for Windows (ETW), you should add a target to your session. Specifically, you need to add the ETW target to your Extended Events session. Add the ETW Target: ALTER EVENT SESSION session1 ON SERVER ADD TARGET package0.etw_classic_sync_target Make sure the SQL Server service startup account is a member of the Performance Log Users group
JJJR 👍 4 Selected: B
The answer is B https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/targets-for-extended-events-in-sql-server?view=sql-server-ver16#etw_classic_sync_target-target https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/event-tracing-for-windows-target?view=sql-server-ver16
pjfunner 👍 1 Selected: B
Answer B seems correct.

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

The correct answer is B. Add a target. Extended Events targets define where the event data is sent and how it is processed. To correlate Extended Events with Event Tracing for Windows (ETW), you must add the etw_classic_sync_target to the session. This target synchronizes Extended Events with ETW, allowing both event streams to be correlated using tools like Windows Performance Recorder or Xperf. The community unanimously supports this, with comments citing the official Microsoft documentation on Extended Events targets.

Why the Other Options Are Wrong

Option A is incorrect because modifying event filters determines which events are captured, not where they are sent or how they correlate with external systems. Option C is wrong because actions add data to an event payload (e.g., collecting a call stack), but do not route events to ETW. Option D is incorrect because specifying data storage settings controls file retention and rollover, not integration with ETW.

Community Comment Notes

Community members strongly agree on answer B, with one commenter providing the exact T-SQL syntax: ADD TARGET package0.etw_classic_sync_target. Multiple comments link to the official Microsoft documentation for the etw_classic_sync_target, reinforcing that this is the only way to bridge Extended Events with ETW. No dissenting opinions were found in the discussion.

Official Reference

Exam Strategy

When a question asks about correlating Extended Events with an external system like ETW, immediately look for the 'Add a target' option. Remember that targets define output destinations, while actions and filters modify the event data itself.

Related Analysis

Note: This question is part of a series of questions that pr

A-Grade

Case study - This is a case study. Case studies are not time

S-Grade

You have an Azure subscription that contains a SQL Server on

A-Grade

Practice All DP-300 Questions

Access 105 questions with complete answers and detailed explanations.

View Full DP-300 Practice Test →

← Back to DP-300 Study Guide