DP-300 · Question #359
DP-300 Question #359: Real Exam Question with Answer & Explanation
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.
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:
Options
- taskRebuild the index for PK_Address_AddressID in the SalesLT.Address table in db1, ensuring that 30 percent of the index page is reserved for future updates and inserts, and minimizing page splits.
- prerequisitesSign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
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.