ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 34 discussion

Actual exam question from Microsoft's DP-600
Question #: 34
Topic #: 1
[All DP-600 Questions]

HOTSPOT -
You have a Fabric tenant that contains two lakehouses.
You are building a dataflow that will combine data from the lakehouses. The applied steps from one of the queries in the dataflow is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by Momoanwar at Feb. 17, 2024, 3:03 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Momoanwar
Highly Voted 1 year, 3 months ago
1: Some.blue icone fold and red dont fold 2 : on power query. all process after the step that dont fold are on power query
upvoted 27 times
...
SamuComqi
Highly Voted 1 year, 3 months ago
The red icon suggests where query folding is interrupted, therefore only SOME steps are folded. All the other steps after the red icon will not fold and will be executed by the POWER QUERY engine.
upvoted 7 times
...
Spam_Account
Most Recent 4 months, 3 weeks ago
Isn't query folding when the query steps are pushed back into the engine, in order to optimise queries? This isn't happening at all, since the red icon occurs immediately after the navigation step. So the entire query WILL necessarily be pulled into power query, so no query folding will occur.
upvoted 2 times
...
Rakesh16
6 months, 2 weeks ago
‘Some’ and ‘The Microsoft Power Query Engine’
upvoted 1 times
...
a_51
1 year, 2 months ago
Correct as shown. If the query folded the work is pushed to the data source. the icons help to tell you if folding is occurring or not. https://learn.microsoft.com/en-us/power-query/step-folding-indicators#step-diagnostics-indicators
upvoted 5 times
...
XiltroX
1 year, 3 months ago
The answers are correct. Some steps will be performed in Query Folding and query folding is only available in MS Power Query engine.
upvoted 2 times
...
NewB87
1 year, 3 months ago
Reference in MS Learn: https://learn.microsoft.com/en-us/power-query/step-folding-indicators
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel