Deal of The Day! 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
Carin
3 days ago
Definitely use the MAX() function to find the maximum values.
upvoted 0 times
...
France
9 days ago
MAX() is the correct function to use here.
upvoted 0 times
...
Alesia
14 days ago
The MAX() function is the way to go for this task.
upvoted 0 times
...
Lashawnda
19 days ago
MAX() is the function you need to identify the maximum values.
upvoted 0 times
...
Dexter
24 days ago
I believe we should look into the Table.Max function, but I need to double-check if it works directly with the columns like we need.
upvoted 0 times
...
Edwin
29 days ago
I’m a bit confused about whether we should use a specific function for each numeric column or if there's a way to apply it to all at once.
upvoted 0 times
...
Selma
2 months 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
2 months 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
2 months 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
2 months 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
2 months ago
Okay, this seems straightforward. I'd use the MAX() function to get the max values for the numeric columns.
upvoted 0 times
...
Erasmo
3 months 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
3 months 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