nerdexam
Microsoft

MB7-702 · Question #37

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…

The correct answer is D. Set the MaintainSIFTlndex property of the key to No. See the full explanation below for the reasoning.

Question

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?

Options

  • ASet the CalcFields property of the table to point to the SumIndexFields.
  • BSet the FieldClass property of each SumIndexField to FlowField.
  • CChange the order of the SumIndexFields.
  • DSet the MaintainSIFTlndex property of the key to No.

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    7% (2)
  • C
    15% (4)
  • D
    74% (20)

Community Discussion

No community discussion yet for this question.

Full MB7-702 Practice