What should you include in the recommendation?

You need to recommend a solution that addresses the index fragmentation and index width issue.

What should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)
A . Change the data type of the lastModified column to smalldatetime.
B . Remove the lastModified column from the clustered index.
C . Change the data type of the modifiedBy column to tinyint.
D . Change the data type of the id column to bigint.
E . Remove the modifiedBy column from the clustered index.
F . Remove the id column from the clustered index.

Answer: B, E

Explanation:

Scenario: Index Fragmentation Issues

Customers discover that clustered indexes often are fragmented. To resolve this issue, the customers defragment the indexes more frequently.

All of the tables affected by fragmentation have the following columns that are used as the clustered index key:

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments