Which command should you use only during the monthly maintenance window?

Correct Answer for the following Question is given below

You are designing your maintenance plan.Which command should you use only during the monthly maintenance window?* Scenario: Database IssuesThe 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 useALTER INDEX REORGANIZE/ > 30%then useALTER INDEX REBUILD WITH (ONLINE = ON)ALTER INDEX (Transact-SQL)

Question:

Which command should you use only during the monthly maintenance window?

Options:

DBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex)

ALTER INDEX SODIndex ON SalesOrderDetail REORGANIZE

ALTER INDEX SODIndex ON SalesOrderDetail REBUILD

ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)

Correct Answer

The Correct Answer for this Question is

ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)

Explanation

The Question – Which command should you use only during the monthly maintenance window? has been answered correctly and answers for the question is ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment