Question 219 of 388
Single answerA 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?
✓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 connection for the datasetD.Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.
✓
Correct Answer: A
Create a dataflows connection that has Import mode selected and schedule a daily refresh.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.