Microsoft
70-459 · Question #23
70-459 Question #23: Real Exam Question with Answer & Explanation
The correct answer is D. FILLFACTOR = 80. See the full explanation below for the reasoning.
Question
You have an index for a table in a SQL Azure database. The database is used for Online Transaction Processing (OLTP). You discover that many page splits occur when records are inserted or updated in the table. You need to minimize the number of page splits. What should you set from the index options?
Options
- AFILLFACTOR = 0
- BSTATISTICS_NORECOMPUTE = ON
- CSTATISTICS_NORECOMPUTE = OFF
- DFILLFACTOR = 80
Community Discussion
No community discussion yet for this question.