Exam 70-764 topic 1 question 17 discussion

Actual exam question from Microsoft's 70-764

Question #: 17
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: C 🗳️
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 that instance.
✑ Expand Databases, expand the database that contains the table with the specified index, and then expand Tables.
✑ 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

by TheSwedishGuy at Jan. 27, 2020, 11:40 a.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 6 months ago

Right-clicking on a table's "Indexes" folder will enable you to rebuild the indexes.

upvoted 2 times

...