Exam DP-500 topic 1 question 68 discussion

Actual exam question from Microsoft's DP-500

Question #: 68
Topic #: 1

HOTSPOT -
You have a Power BI dataset that has the query dependencies 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

Suggested Answer:

by JasonVu at Dec. 11, 2022, 3:23 p.m.

Comments

Submit Cancel

Arnaudvdc1981

Highly Voted 2 years, 6 months ago

Orders query is executed 3 times but creating a dataflow will reduce data refresh times, not the table.buffer https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries

upvoted 18 times

...

6688Wj

Highly Voted 2 years, 6 months ago

3 and Dataflow

upvoted 10 times

...

SamuComqi

Most Recent 1 year, 10 months ago

I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - 3 - Replacing the Orders query with a dataflow

upvoted 4 times

...

Eltooth

2 years ago

3 Dataflow

upvoted 2 times

...

cherious

2 years, 5 months ago

3 and Dataflow. When the data model is refreshed, it's often assumed that Power Query retrieves the Query1 result, and that it's reused by referenced queries. This thinking is incorrect. In fact, Power Query executes Query2, Query3, and Query4 separately. Query1 is executed three times. The multiple executions can result in slow data refresh, and negatively impact on the data source. The use of the Table.Buffer function in Query1 won't eliminate the additional data retrieval. We recommend you create a dataflow instead. Using a dataflow can improve data refresh time, and reduce impact on your data sources. Source: https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries

upvoted 7 times

...

JasonVu

2 years, 6 months ago

should be 0

upvoted 2 times

JasonVu

2 years, 6 months ago

*3*. Did not see the reference query

upvoted 4 times

...