Which Power Query function should you use to identify the maximum values for numeric columns when loading a new dataset from OneLake into the warehouse?

Which Power Query function should you use to identify the maximum values for numeric columns when loading a new dataset from OneLake into the warehouse?

• A. Table.MaxN
• B. Table.Max
• C. Table.Range
• D. Table.Profile

Answer: (D)

Table.Profile is the right tool because it generates a per-column data profile that includes, among other stats, the maximum value for numeric columns. This lets you quickly see the upper bounds of all numeric fields when loading a new dataset from OneLake into the warehouse, without writing extra aggregations. Other functions don’t provide a column-by-column max profile. Table.MaxN focuses on returning the largest rows, Table.Max isn’t about producing a per-column statistics profile, and Table.Range generates a range of values rather than a summary of each column’s bounds.

Table.Profile is the right tool because it generates a per-column data profile that includes, among other stats, the maximum value for numeric columns. This lets you quickly see the upper bounds of all numeric fields when loading a new dataset from OneLake into the warehouse, without writing extra aggregations.

Other functions don’t provide a column-by-column max profile. Table.MaxN focuses on returning the largest rows, Table.Max isn’t about producing a per-column statistics profile, and Table.Range generates a range of values rather than a summary of each column’s bounds.