PrepAway - Latest Free Exam Questions & Answers

Which two actions will help you to further increase performance of the archive? (Choose two.)

You discovered a slow performance issue during an archive process with delete deferred. By using the Statistical Report and the Relationship Index Analysis, you were able to determine that there was a missing index on one of the tables. The index has been added to the database, and the Statistical Report reflects that the index is being used for a key lookup. Performance has improved somewhat. Which two actions will help you to further increase performance of the archive? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Force a scan on this table.

B.
Increase your commit frequency.

C.
Use more than one database connection for the archive process.

D.
Increase the Key Lookup Limit for this table.

E.
Turn the Compare Rows option off.


Leave a Reply