Microsoft
DP-300 · Question #359
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
Sign in or unlock DP-300 to reveal the answer and full explanation for question #359. The question stem and answer options stay visible for context.
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
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Index Maintenance#FILLFACTOR#SQL Server#Page Splits