Questions

1. What were the four key tips for optimizing M queries discussed this chapter?
   1. Sorting, filtering, grouping, summarizing
   2. Filtering and reducing data, using native M functions, creating custom functions, optimizing memory usage
   3. Conditional formatting, joins, aggregations, pivoting
   4. Concatenation, union, splitting, transforming
2. In the custom function for calculating the weighted average, what are the parameters of the function, and how is the weighted average calculated?
   1. Parameters: table, weights, values; the weighted average is calculated by summing the weighted values and dividing by the total weight
   2. Parameters: table, columns; the weighted average is calculated by multiplying values by weights
   3. Parameters: values, weights, total; the weighted average is calculated by summing the values and dividing by the weights
   4. Parameters: rows, weights, values; the weighted average is calculated by summing the values and multiplying by the weights
3. How can Table.Buffer optimize the...