Implementing Analytics Solutions Using Microsoft Fabric — Question 190

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 Power Query step to identify the maximum values for the numeric columns.

Which function should you include in the step?

Answer options

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

Correct answer: C

Explanation

The correct answer is C, Table.Profile, as it generates a profile of the data, including statistics like maximum values for numeric columns. Options A and B do not provide the necessary functionality to identify maximum values in the context described, making them unsuitable for this requirement.