You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com ABC.com subscribes to SQL Azure, which hosts a ABC.com database used for Online

Transaction Processing (OLTP).
A table in the database contains an index. You have found that inserting or updating records in the
table results in numerous page splits taking place.
You want to make sure that page splits are reduced.
Which of the following actions should you take?

A.
You should consider modifying the DATA_COMPRESSION index option.

B.
You should consider modifying the MAXDOP index option.

C.
You should consider modifying the ON PARTITIONS index option.

D.
You should consider modifying the FILLFACTOR index option.

Explanation: