Administering a SQL Database Infrastructure — Question 20

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have an on-premises server that runs Microsoft SQL Server 2016 Standard Edition.
You need to identify missing indexes.
What should you use?

Answer options

• A. Activity Monitor
• B. Sp_who3
• C. SQL Server Management Studio (SSMS) Object Explorer
• D. SQL Server Data Collector
• E. SQL Server Data Tools (SSDT)
• F. SQL Server Configuration Manager

Correct answer: D

Explanation

The SQL Server Data Collector is specifically designed to gather and analyze performance data, including identifying missing indexes. The other options do not provide the necessary functionality for this task: Activity Monitor shows current activity, Sp_who3 is for monitoring users, SSMS Object Explorer is a management interface, SQL Server Data Tools is for development, and SQL Server Configuration Manager is for configuration tasks.