Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K 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
Options
MB7-702 SIFT Indexes Question
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
Sum, Avg and Count are aggregate functions (that are sum based)
Reference: http://msdn.microsoft.com/en-us/library ... 70%29.aspx
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