070-465J Free Dumps Study Materials
Question 10: あなたはメンテ ナンス計画をデザインしている。
あなたは毎月のメンテナンスウィンドウの間にだけ、どのコマンドを使うべきであるか?
A. DBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex)
B. ALTER INDEX SODIndex ON SalesOrderDetail REORGANIZE
C. ALTER INDEX SODIndex ON SalesOrderDetail REBUILD
D. ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)
Correct Answer: D
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%
then use
ALTER INDEX REORGANIZE
/ > 30%
then use
ALTER INDEX REBUILD WITH (ONLINE = ON)
ALTER INDEX (Transact-SQL)