New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-600 Exam - Topic 1 Question 46 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 46
Topic #: 1
[All DP-600 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

The Table.Max function should be used in a Power Query step to identify the maximum values for the numeric columns. This function is designed to calculate the maximum value across each column in a table, which suits the requirement of finding maximum values for numeric columns. Reference = For detailed information on Power Query functions, including Table.Max, please refer to Power Query M function reference.


by Levi at Jan 26, 2026, 08:03 PM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Selma
5 days ago
I remember practicing a similar question where we had to aggregate data, and I think we used the Group By feature. Could that be relevant here?
upvoted 0 times
...
Milly
10 days ago
I think we might need to use the List.Max function to find the maximum values, but I'm not entirely sure if that's the right one for Power Query.
upvoted 0 times
...
Lavera
15 days ago
The MAX() function should do the trick. I'd apply that to each of the numeric columns to get the max values.
upvoted 0 times
...
Martina
20 days ago
I'm a bit confused on this one. Is there a specific Power Query function for finding the max values across multiple columns?
upvoted 0 times
...
Jacki
25 days ago
Okay, this seems straightforward. I'd use the MAX() function to get the max values for the numeric columns.
upvoted 0 times
...
Erasmo
1 month ago
Hmm, not sure about this one. I'll need to review the Power Query documentation to figure out the right function for that.
upvoted 0 times
...
Willard
1 month ago
I think I'd start by looking at the available Power Query functions to see which one can find the max values for numeric columns.
upvoted 0 times
...

Save Cancel