- All Categories
- 73 General
- 73 Announcements
- 66.3K Microsoft Dynamics NAV
- 18.4K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 614 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 237 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 33 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

ccorreia
Member Posts: **36**

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

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

0

## Comments

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

Reference: http://msdn.microsoft.com/en-us/library ... 70%29.aspx

82COUNTandAVERAGEformulas 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