Microsoft
70-459 · Question #5
You have an index for a table in a SQL Azure database. The database is used for Online Transaction Processing (OLTP). You discover that the index consumes more physical disk space than necessary…
The correct answer is C. FILLFACTOR = 0. 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 the index consumes more physical disk space than necessary. You need to minimize the amount of disk space that the index consumes. What should you set from the index options?
Options
- ASTATISTICS_NORECOMPUTE = OFF
- BSTATISTICS_NORECOMPUTE = ON
- CFILLFACTOR = 0
- DFILLFACTOR = 80
How the community answered
(47 responses)- A4% (2)
- B11% (5)
- C83% (39)
- D2% (1)
Community Discussion
No community discussion yet for this question.