PrepAway - Latest Free Exam Questions & Answers

How would you deframent the indexes without causing too much unavailability of the table?

You work as a database administrator at ABC.com. ABC.com has a database named ABC_DB.
ABC_DB has a table named ABC_Prod that has over 100,000 rows. Several indexes that have
been created on the ABC_Prod tableare fragmented.
How would you deframent the indexes without causing too much unavailability of the table?

PrepAway - Latest Free Exam Questions & Answers

A.
You should change the indexes to use the Full index option.

B.
You should change the indexes to use the Page index option.

C.
You should change the indexes to use the Online option.

D.
You should change the indexes to use the Offline option.

E.
You should change the indexes to use the Clustered index option.

Explanation:


Leave a Reply