PrepAway - Latest Free Exam Questions & Answers

How can you minimize the size of the index?

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply