Microsoft Exam Questions

Which change will diminish the time it takes to create, modify, and delete records?

You add a new key with a number of SumIndexFields to an existing custom table. Users
report that creating, modifying, and deleting records in the table takes more time than
expected. Which change will diminish the time it takes to create, modify, and delete records?

A.
Set the CalcFields property of the table to point to the SumIndexFields.

B.
Set the FieldClass property of each SumIndexField to FlowField.

C.
Change the order of the SumIndexFields.

D.
Set the MaintainSIFTlndex property of the key to No.