Microsoft
70-459 · Question #86
You are designing your maintenance plan. Which command should you use only during the monthlymaintenance window?
The correct answer is D. ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON). Scenario: Database Issues The current database does not perform well. Additionally, a recent disk problem caused the system to go down, resulting in lost sales revenue. In reviewing the current system, you found that there are no automated maintenance procedures. The database…
Administer SQL Server
Question
You are designing your maintenance plan. Which command should you use only during the monthlymaintenance window?
Options
- ADBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex)
- BALTER INDEX SODIndex ON SalesOrderDetail REORGANIZE
- CALTER INDEX SODIndex ON SalesOrderDetail REBUILD
- DALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)
How the community answered
(32 responses)- A3% (1)
- B16% (5)
- C9% (3)
- D72% (23)
Explanation
- Scenario: Database Issues The current database does not perform well. Additionally, a recent disk problem caused the system to go down, resulting in lost sales revenue. In reviewing the current system, you found that there are no automated maintenance procedures. The database is severely fragmented, and everyone has read and write access. * After the degree of fragmentation is known, use the following table to determine the best method to correct the fragmentation. avg_fragmentation_in_percent value / > 5% and < = 30% ALTER INDEX REORGANIZE ALTER INDEX REBUILD WITH (ONLINE = ON) ALTER INDEX (Transact-SQL)
Topics
#index maintenance#online index rebuild#ALTER INDEX#maintenance window
Community Discussion
No community discussion yet for this question.