Microsoft Exam DP-600 Topic 3 Question 35 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 35
Topic #: 3

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?

Aan Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouse

Ban Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderlD column in the destination lakehouse

Can Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderlD column in the destination lakehouse

Dan Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the OrderiD column m the
destination lakehouse

Show Suggested Answer

Suggested Answer: C

by Deangelo at Apr 03, 2025, 11:42 AM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Casie

15 days ago

I don't know, but I'm guessing the 'lakehouse' is some kind of fancy data storage solution. Probably requires a boat and water skis to access the data.

upvoted 0 times

...

Dorothy

16 days ago

Hold up, are we talking about a lake or a house? I'm starting to get confused here. Can we get some clarification on this 'lakehouse' thing?

upvoted 0 times

...

Joye

1 months ago

Hmm, I think option B might be the best choice. Using a Stored Procedure activity to get the max OrderlD value could be more efficient than a dataflow.

upvoted 0 times

Lorenza

9 days ago

I agree, option B seems like the most efficient choice.

upvoted 0 times

...

Idella

1 months ago

I'm not sure why we need to fetch the minimum or maximum value. Shouldn't we just be copying the entire Orders table to the lakehouse?

upvoted 0 times

Ashton

8 days ago

C) an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderlD column in the destination lakehouse

upvoted 0 times

...

Felix

9 days ago

B) an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderlD column in the destination lakehouse

upvoted 0 times

...

Angella

24 days ago

A) an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouse

upvoted 0 times

...

Cristal

28 days ago

User3: Why not just copy the entire Orders table to the lakehouse instead of fetching minimum or maximum values?

upvoted 0 times

...

Jesusa

30 days ago

User2: I think we should also consider a pipeline that retrieves the maximum value of the OrderID column.

upvoted 0 times

...

Adell

1 months ago

User1: We need to include a pipeline that retrieves the minimum value of the OrderID column.

upvoted 0 times

...

Roslyn

2 months ago

Option C looks like the way to go. Retrieving the maximum OrderlD value in the destination lakehouse seems like the right approach to refresh the Orders table.

upvoted 0 times