PrepAway - Latest Free Exam Questions & Answers

What should you set from the index options?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
STATISTICS_NORECOMPUTE = OFF

B.
FILLFACTOR = 80

C.
FILLFACTOR = 0

D.
STATISTICS_NORECOMPUTE = ON

Explanation:
http://msdn.microsoft.com/en-us/library/ms177459.aspx
http://msdn.microsoft.com/en-us/library/ms188783.aspx

One Comment on “What should you set from the index options?


Leave a Reply