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

Exam DP-500 All Questions

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

Exam DP-500 topic 1 question 68 discussion

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

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 Hide Answer
Suggested Answer:
by JasonVu at Dec. 11, 2022, 3:23 p.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
Arnaudvdc1981
Highly Voted 2 years, 8 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, 7 months ago
3 and Dataflow
upvoted 10 times
...
SamuComqi
Most Recent 1 year, 11 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, 1 month ago
3 Dataflow
upvoted 2 times
...
cherious
2 years, 7 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, 8 months ago
should be 0
upvoted 2 times
JasonVu
2 years, 8 months ago
*3*. Did not see the reference query
upvoted 4 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