Answer-first summary for fast verification
Answer: Table.Profile
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.
Author: LeetQuiz Editorial Team
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