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?

DTable.Profile

CTable.Range

BTable.Max

ATable. MaxN

Show Suggested 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:

Submit Cancel

Lajuana

2 months ago

Max() isn’t specific to lists. List.Max is the right choice here.

upvoted 0 times

...

Olive

2 months ago

I’m not sure. What about using Max() function instead?

upvoted 0 times

...

Dortha

2 months ago

Yeah, List.Max is straightforward. It’s efficient for numeric columns.

upvoted 0 times

...

Catarina

2 months ago

I think the answer is List.Max. It makes sense for max values.

upvoted 0 times

...

Afton

2 months ago

Yup, List.Max is definitely the one you need!

upvoted 0 times

...

Merissa

4 months ago

I think there's also Max() in DAX, but not sure if it applies here.

upvoted 0 times

...

Hermila

4 months ago

Wait, are you sure that's the only function?

upvoted 0 times

...

Leonie

4 months ago

Totally agree, that's the right way to go.

upvoted 0 times

...

Norah

4 months ago

You should use the List.Max function!

upvoted 0 times

...

Shelba

5 months ago

MAX() is the function that will do the trick for this problem.

upvoted 0 times

...

Dianne

5 months ago

MAX() is the function you should include in the Power Query step.

upvoted 0 times

...

Carin

5 months ago

Definitely use the MAX() function to find the maximum values.

upvoted 0 times

...

France

5 months ago

MAX() is the correct function to use here.

upvoted 0 times

...

Alesia

5 months ago

The MAX() function is the way to go for this task.

upvoted 0 times

...

Lashawnda

5 months ago

MAX() is the function you need to identify the maximum values.

upvoted 0 times

...

Dexter

6 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

6 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

7 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

7 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

7 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

7 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

7 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

7 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

8 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

Dominga

1 month ago

I think we should also consider using Table.Max for specific columns.

upvoted 0 times

...

Annice

1 month ago

Yeah, that seems like a good option for max values.

upvoted 0 times

...

Rosendo

2 months ago

Have you checked the List.Max function?

upvoted 0 times

...