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

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?
B) Table.Max
D) Table.Profile
C) Table.Range
A) Table. MaxN

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
Lajuana
5 days ago
Max() isn’t specific to lists. List.Max is the right choice here.
upvoted 0 times
...
Olive
10 days ago
I’m not sure. What about using Max() function instead?
upvoted 0 times
...
Dortha
15 days ago
Yeah, List.Max is straightforward. It’s efficient for numeric columns.
upvoted 0 times
...
Catarina
20 days ago
I think the answer is List.Max. It makes sense for max values.
upvoted 0 times
...
Afton
26 days ago
Yup, List.Max is definitely the one you need!
upvoted 0 times
...
Merissa
2 months ago
I think there's also Max() in DAX, but not sure if it applies here.
upvoted 0 times
...
Hermila
3 months ago
Wait, are you sure that's the only function?
upvoted 0 times
...
Leonie
3 months ago
Totally agree, that's the right way to go.
upvoted 0 times
...
Norah
3 months ago
You should use the List.Max function!
upvoted 0 times
...
Shelba
3 months ago
MAX() is the function that will do the trick for this problem.
upvoted 0 times
...
Dianne
3 months ago
MAX() is the function you should include in the Power Query step.
upvoted 0 times
...
Carin
3 months ago
Definitely use the MAX() function to find the maximum values.
upvoted 0 times
...
France
4 months ago
MAX() is the correct function to use here.
upvoted 0 times
...
Alesia
4 months ago
The MAX() function is the way to go for this task.
upvoted 0 times
...
Lashawnda
4 months ago
MAX() is the function you need to identify the maximum values.
upvoted 0 times
...
Dexter
4 months 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
4 months 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
5 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
5 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
5 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
6 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
6 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
6 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
6 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