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

Microsoft DP-600 Exam - Topic 1 Question 46 Discussion

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

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?

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.


Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
27 comments · newest first
LA
Lajuana 4 months ago
Max() isn’t specific to lists. List.Max is the right choice here.
OL
Olive 4 months ago
I’m not sure. What about using Max() function instead?
DO
Dortha 4 months ago
Yeah, List.Max is straightforward. It’s efficient for numeric columns.
CA
Catarina 4 months ago
I think the answer is List.Max. It makes sense for max values.
AF
Afton 5 months ago
Yup, List.Max is definitely the one you need!
ME
Merissa 6 months ago
I think there's also Max() in DAX, but not sure if it applies here.
HE
Hermila 6 months ago
Wait, are you sure that's the only function?
LE
Leonie 6 months ago
Totally agree, that's the right way to go.
NO
Norah 7 months ago
You should use the List.Max function!
SH
Shelba 7 months ago
MAX() is the function that will do the trick for this problem.
DI
Dianne 7 months ago
MAX() is the function you should include in the Power Query step.
CA
Carin 7 months ago
Definitely use the MAX() function to find the maximum values.
FR
France 7 months ago
MAX() is the correct function to use here.
AL
Alesia 7 months ago
The MAX() function is the way to go for this task.
LA
Lashawnda 8 months ago
MAX() is the function you need to identify the maximum values.
DE
Dexter 8 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.
ED
Edwin 8 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.
SE
Selma 9 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?
MI
Milly 9 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.
LA
Lavera 9 months ago
The MAX() function should do the trick. I'd apply that to each of the numeric columns to get the max values.
MA
Martina 9 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?
JA
Jacki 9 months ago
Okay, this seems straightforward. I'd use the MAX() function to get the max values for the numeric columns.
ER
Erasmo 10 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.
WI
Willard 10 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.
DO
Dominga 3 months ago
↳ replying to Willard
I think we should also consider using Table.Max for specific columns.
AN
Annice 4 months ago
↳ replying to Willard
Yeah, that seems like a good option for max values.
RO
Rosendo 4 months ago
↳ replying to Willard
Have you checked the List.Max function?
0/2000 characters

Save Cancel