Microsoft Exam 70-765 Topic 1 Question 5 Discussion

Actual exam question for Microsoft's 70-765 exam

Question #: 5
Topic #: 1

You administer a Microsoft SQL Server 2014 database that contains a table named OrderDetail.

You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline.

Which Transact-SQL batch should you use?

ACREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING

BALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE

CALTER INDEX ALL ON OrderDetail REBUILD

DALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD

Show Suggested Answer

Suggested Answer: B

REORGANIZE specifies to reorganize the index leaf level. The REORGANIZE operation is always performed online. This means long-term blocking table locks are not held and queries or updates to the underlying table can continue during the ALTER INDEX REORGANIZE transaction.

References:https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql

by Leota at May 03, 2022, 02:39 PM

Limited Time Offer

25%

Off

Get Premium 70-765 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!