Chapter 11 – M Query Optimization

1. B – Filtering and reducing data, using native M functions, creating custom functions, optimizing memory usage – These are the four key tips to optimizing M queries
2. A – Parameters: table, weights, values; the weighted average is calculated by summing the weighted values and dividing by the total weight – The function takes three parameters (table, weights, values) and calculates the weighted average by summing the weighted values and dividing by the total weight.
3. C – It loads a table into memory once, reducing memory duplication – Table.Buffer is used to load a table into memory only once, reducing memory duplication and improving query speeds on subsequent steps. Note though that it can also have the reverse effect as the initial reading and loading of the data can cause your query to run more slowly.
4. B – Splits a table into smaller partitions for parallel processing –...