PL-300 · Question #219
A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned o
The correct answer is A. Create a dataflows connection that has Import mode selected and schedule a daily refresh.. One of the requirements is 'Minimize online processing operations'. Although the dataflow uses DirectQuery, the Dataset can be refreshed with Import. https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-directquery
Question
A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements:
- Minimize online processing operations.
- Minimize calculation times and render times for visuals.
- Include data from the current year, up to and including the previous
day. What should you do?
Options
- ACreate a dataflows connection that has Import mode selected and schedule a daily refresh.
- BCreate a dataflows connection that has DirectQuery mode selected.
- CCreate a dataflows connection that has DirectQuery mode selected and configure a gateway
- DCreate a dataflows connection that has Import mode selected and create a Microsoft Power
How the community answered
(38 responses)- A79% (30)
- B3% (1)
- C5% (2)
- D13% (5)
Explanation
One of the requirements is 'Minimize online processing operations'. Although the dataflow uses DirectQuery, the Dataset can be refreshed with Import. https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-directquery
Topics
Community Discussion
No community discussion yet for this question.