Question 20
A manufacturing dashboard must reflect database transactions nearly immediately and policy forbids persisting source rows inside Power BI. Which action is most appropriate for the stated business outcome?
Explanation
Correct Answer
DirectQuery sends supported visual queries to the source instead of storing imported fact rows. It meets the scenario requirement of live operational data without model caching.
Incorrect Answers
Direct Lake reads underlying Delta data using the tabular engine and avoids a conventional full import duplicate. It would instead address querying lakehouse Delta tables directly, not the stated live operational data without model caching.
Reusing the shared semantic model centralizes metric definitions and existing managed relationships. That alternative targets reporting on governed enterprise measures; this case requires live operational data without model caching.
Import materializes compressed data in the model and queries it without contacting the operational source on each interaction. It may be appropriate for low-latency cached historical analytics, whereas the current need is live operational data without model caching.






Microsoft Power BI Data Analyst (PL-300) Practice Tests