Administering a SQL Database Infrastructure — Question 137

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.
You need to collect data for a long period of time to troubleshoot wait statistics when querying Contoso.
You also need to ensure minimum impact to the server.
What should you create?

Answer options

• A. An Alert
• B. A Resource Pool
• C. An Extended Event session
• D. A Server Audit Specification
• E. A SQL Profiler Trace
• F. A Database Audit Specification
• G. A Policy

Correct answer: C

Explanation

Creating an Extended Event session is the correct approach as it is designed to collect data with low overhead, making it suitable for long-term monitoring of wait statistics. Other options like SQL Profiler Trace can be more intrusive and impact server performance, while Resource Pools, Alerts, and Audit Specifications do not specifically address the need for detailed wait statistics collection.