Question 440
A small reference dimension rarely changes and does not need every visual to query an external database. Which configuration should the team choose?
Explanation
Correct Answer
Local reference data can reduce remote query cost, supporting cache slow-changing lookup attributes.
Incorrect Answers
Composite models can incur costly cross-source query behavior. It would address reduce federated model execution cost, not cache slow-changing lookup attributes.
Fallback execution can increase latency and change query behavior. That targets mitigate Direct Lake query fallback, not cache slow-changing lookup attributes.
Dual dimensions can serve cached Import queries and DirectQuery relationships depending on execution context. It is useful for optimize hybrid model dimensions, not for cache slow-changing lookup attributes.






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