You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
A server named ABC-SQL1 hosts an Online Transaction Processing (OLTP) database named
ABC-DB1. The available disk space on ABC-SQL1 is running low. You discover that the index for
a table in ABC-DB1 is using a large amount of disk space.
You want to free up some disk space by minimizing the size of the index.
How can you minimize the size of the index?
A.
Configure a FILLFACTOR value of 0 in the index options.
B.
Configure a FILLFACTOR value of 20 in the index options.
C.
Configure a FILLFACTOR value of 80 in the index options.
D.
Reorganize the index.
Explanation: