Microsoft
70-433 · Question #210
Your database is 5GB and contains a table named SalesHistory. Sales information is frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occu
Sign in or unlock 70-433 to reveal the answer and full explanation for question #210. The question stem and answer options stay visible for context.
Troubleshoot and Optimize Databases
Question
Your database is 5GB and contains a table named SalesHistory. Sales information is frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurrence of page splitting in the SalesHistory table. Which code segment should you use?.
Options
- AALTER DATABASE Sales MODIFY FILE
- BALTER INDEX ALL ON Sales.SalesHistory
- CEXEC sys.sp_configure 'fill factor (%)', '60';
- DUPDATE STATISTICS Sales.SalesHistory(Products)
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 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
#page splitting#fill factor#index rebuild#index fragmentation