Extended Events Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Performance Monitoring

What you'll be asked

  1. Which component in SQL Server Extended Events is responsible for defining the specific data points to be collected when an event fires?
  2. You need to capture only those queries that take longer than 500 milliseconds to execute. Which Extended Events component should you use to achieve this filtering?
  3. Which target is best suited for viewing Extended Events data in real-time within SQL Server Management Studio (SSMS) without writing T-SQL queries?
  4. When configuring an Extended Events session, what is the primary advantage of using the 'event_file' target over the 'ring_buffer' target for long-running traces?
  5. You are troubleshooting a high-concurrency environment and notice that your Extended Events session is causing significant performance degradation. Which configuration setting is most likely to mitigate this impact while still capturing data?

Answers and explanations come after you submit.