Implementing Analytics Solutions Using Microsoft Fabric — Question 21

You have a Fabric tenant that contains a warehouse.
You use a dataflow to load a new dataset from OneLake to the warehouse.
You need to add a PowerQuery step to identify the maximum values for the numeric columns.
Which function should you include in the step?

Answer options

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

Correct answer: D

Explanation

The correct answer is D, Table.Profile, as it provides insights into the data, including maximum values for numeric columns. Options A and B, Table.MaxN and Table.Max, do not exist within PowerQuery for this specific purpose, while C, Table.Range, is used for returning a specified range of rows rather than summarizing maximum values.