PrepAway - Latest Free Exam Questions & Answers

Which of the following actions should you take?

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 that makes use of too much physical disk space. You
have been instructed to make sure that the physical disk space used by the index is reduced.
Which of the following actions should you take?

PrepAway - Latest Free Exam Questions & Answers

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 FILLFACTOR index option.

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

Explanation:

2 Comments on “Which of the following actions should you take?


Leave a Reply