Explanation:
The correct answer is D. Table.Profile. The Table.Profile function returns a summary of the columns in a table, including the maximum values for numeric columns. This function is appropriate for identifying maximum values for each numeric column in a dataset. Table.Max, on the other hand, only returns the largest value for a single specified column, which would require multiple steps to cover all numeric columns. Therefore, Table.Profile is more efficient and suitable for this requirement.
Ultimate access to all questions.
No comments yet.
Your organization utilizes a Fabric tenant that hosts a data warehouse, and you regularly manage datasets within this environment. Currently, you are in the process of loading a new dataset from OneLake into this warehouse using a dataflow. In order to process this dataset effectively, you must add a step in PowerQuery to determine the highest values present in the numeric columns of the dataset. Which function should you incorporate in this PowerQuery step to achieve this objective?
A
Table.MaxN
B
Table.Max
C
Table.Range
D
Table.Profile