exam questions

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam

Exam DP-500 topic 1 question 111 discussion

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

You are optimizing a dataflow in a Power BI Premium capacity. The dataflow performs multiple joins.
You need to reduce the load time of the dataflow.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Execute foldable operations before non-foldable operations.
  • B. Place the ingestion operations and transformation operations in a single dataflow.
  • C. Execute non-foldable operations before foldable operations.
  • D. Place the ingestion operations and transformation operations in separate dataflows.
  • E. Reduce the memory assigned to the dataflows.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

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
PrudenceK
2 years ago
Selected Answer: AD
To reduce the load time of a dataflow in Power BI Premium, you should consider the following actions: A. Execute foldable operations before non-foldable operations: Foldable operations can be pushed down to the data source and executed there, reducing the amount of data transferred to Power BI. By executing foldable operations early in the dataflow, you can minimize the data transfer and improve performance. D. Place the ingestion operations and transformation operations in separate dataflows: Separating ingestion operations (such as loading data from a source) and transformation operations (such as data cleansing or joining) into separate dataflows can help optimize the load time. In this way, the ingestion operations can be executed less frequently, while the transformation operations can be performed on an as-needed basis, reducing the overall load time. These actions aim to optimize the dataflow's performance by leveraging foldable operations and optimizing the workflow structure.
upvoted 2 times
...
louisaok
2 years, 5 months ago
Selected Answer: AD
For A: *Query folding is the mechanism to push Power Query transformations back to the source to reduce the load of Power Query…. The query is much more complicated, as it has to merge (Join) the source tables to form the result. But the database engine is optimised for doing such stuff and will perform this task much better than Power Query. https://towardsdatascience.com/exploring-query-folding-in-power-query-8288fb3c9c2f
upvoted 4 times
...
cherious
2 years, 6 months ago
Selected Answer: AD
The answer is correct. You should split the ETL stage into two separate dataflows. Source: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features?tabs=gen2#using-the-enhanced-compute-engine
upvoted 3 times
...
AshwinN1992
2 years, 6 months ago
Please confirm
upvoted 2 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
Loading ...