Administering a SQL Database Infrastructure — Question 106

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 observe that several indexes are fragmented.
You need to rebuild the indexes.
What should you use?

Answer options

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

Correct answer: C

Explanation

The correct answer is C, as Object Explorer in SQL Server Management Studio (SSMS) allows you to manage and rebuild indexes directly. The other options, such as Activity Monitor and SQL Server Data Collector, do not provide the specific functionality needed for index management, while Sp_who3 is used for monitoring processes and SQL Server Configuration Manager is for server configuration tasks.