What should you use?

You observe that several indexes are fragmented.

You need to rebuild the indexes.

What should you use?
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

View Answer

Answer: C

Explanation:

How to: Rebuild an Index (SQL Server Management Studio)

To rebuild an index

In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand thatinstance.

Expand Databases, expand the database that contains the table with the specified index, and then expandTables.

Expand the table in which the index belongs and then expand Indexes.

Right-click the index to rebuild and then click Rebuild.

To start the rebuild operation, click OK.

References: https://technet.microsoft.com/en-us/library/ms187874(v=sql.105).aspx