MB7-702 SIFT Indexes Question

ccorreia
ccorreia Member Posts: 36
edited 2014-04-04 in NAV Courses, Exams & Certification
I'm checking an practice exam that has this question:

Which FlowField methods are SIFT Indexes used for?
A)LOOKUP, MAX, and MIN
B)COUNT, AVERAGE, and SUM
C)SUM, AVERAGE, and LOOKUP
D)COUNT, MAX, and MIN

The answer in the exam is A.


But for what I seen SIFT is used for Fast calculation of sums.

So A and D are wrong, because don't have the SUM, I think that C is wrong because SIFT isn't used for LOOKUP.
By exclusion we only have the B, but I don't know how to find information about COUNT and AVERAGE using SIFT Indexes, but as they also are calculations, I would expect that can be used for Flowfields.

What are the thoughts of users of this forum :)

Comments

  • humaid
    humaid Member Posts: 1
    B seems the correct answer.

    Sum, Avg and Count are aggregate functions (that are sum based)

    Reference: http://msdn.microsoft.com/en-us/library ... 70%29.aspx
  • azerty74
    azerty74 Member Posts: 82
    SIFT indexes are improved.
    COUNT and AVERAGE formulas can now also use SIFT indexes.
    MIN and MAX formulas now use SQL Server MIN and MAX functions exclusively.

    This info is in the MOC for the C/SIDE Solution Development course :)
    Debugging is twice as hard as writing code. Therefore if you write the code as cleverly as possible you are by definition not smart enough to debug it.

Categories