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

Merissa

25 days ago

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

upvoted 0 times

...

Hermila

1 month ago

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

upvoted 0 times

...

Leonie

1 month ago

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

upvoted 0 times

...

Norah

1 month ago

You should use the List.Max function!

upvoted 0 times

...

Shelba

2 months ago

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

upvoted 0 times

...

Dianne

2 months ago

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

upvoted 0 times

...

Carin

2 months ago

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

upvoted 0 times

...

France

2 months ago

MAX() is the correct function to use here.

upvoted 0 times

...

Alesia

2 months ago

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

upvoted 0 times

...

Lashawnda

2 months ago

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

upvoted 0 times

...

Dexter

3 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

3 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

3 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

4 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

4 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

4 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

4 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

4 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

5 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

...