SIMULATION You need to rebuild the index for PK_Address_AddressID in the SalesLT.Address table in db1. The solution must meet the following requirements: - Ensure that 30 percent of the index page…

Submitted by naveen.iyer· Mar 6, 2026Database Administration – Managing and Optimizing Database Objects and Performance (Azure SQL / SQL Server index management)

Question

SIMULATION You need to rebuild the index for PK_Address_AddressID in the SalesLT.Address table in db1. The solution must meet the following requirements: - Ensure that 30 percent of the index page is reserved for future updates and inserts. - Minimize page splits. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal. Answer:

Exhibit

Explanation

Rebuilding an index with FILLFACTOR set to 70 ensures that 30% of each index page is left empty (reserved) for future inserts and updates, directly satisfying the requirement. This approach minimizes page splits because the reserved free space accommodates new data without requiring pages to be split, which is the primary cause of fragmentation and performance degradation. The correct T-SQL syntax is: ALTER INDEX PK_Address_AddressID ON SalesLT.Address REBUILD WITH (FILLFACTOR = 70), or equivalently via SSMS Index Properties by setting the Fill Factor to 70 under the 'Fragmentation' page.

Topics

#Index Maintenance#FILLFACTOR#SQL Server#Page Splits

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice