Developing SQL Databases — Question 94

You have an existing Microsoft SQL Trace script. You plan to convert the script to an Extended Events session.
You need to collect the trace ID and other required information.
Which system table should you use?

Answer options

• A. dbo.sysnotifications
• B. dbo.syssessions
• C. trace_xe_action_map
• D. sysdbmainplans

Correct answer: C

Explanation

The correct answer is C, trace_xe_action_map, as it contains the mapping of actions to events in Extended Events, which is essential for collecting trace information. The other options do not provide the required data for this transition, with dbo.sysnotifications and dbo.syssessions relating to notifications and session management, and sysdbmainplans being irrelevant to trace data.