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

2 months 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

2 months 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

Viola

23 days ago

It's just a term used to refer to a data storage system. Don't worry about the name, focus on the solution.

upvoted 0 times

...

Queen

26 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

...

Annice

29 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

...

Joye

2 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

Helene

1 months ago

I'm leaning towards option B as well, using a Stored Procedure activity sounds like a good approach.

upvoted 0 times

...

Ronny

1 months ago

I think option A could also work well for this scenario.

upvoted 0 times

...

Lorenza

2 months ago

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

upvoted 0 times

...

Idella

3 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

2 months 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

2 months 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

2 months 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

2 months ago

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

upvoted 0 times

...

Jesusa

2 months ago

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

upvoted 0 times

...

Adell

2 months ago

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

upvoted 0 times

...

Roslyn

3 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