70-459 · Question #49
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
The correct answer is B. Remove the lastModified column from the clustered index. E. Remove the modifiedBy column from the clustered index.. 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
Question
Exhibit
Options
- AChange the data type of the lastModified column to smalldatetime.
- BRemove the lastModified column from the clustered index.
- CChange the data type of the modifiedBy column to tinyint.
- DChange the data type of the id column to bigint.
- ERemove the modifiedBy column from the clustered index.
- FRemove the id column from the clustered index.
How the community answered
(59 responses)- A12% (7)
- B76% (45)
- C7% (4)
- D3% (2)
- F2% (1)
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:
Topics
Community Discussion
No community discussion yet for this question.