Question 210
A Fabric platform reviewer is assessing this situation: A model creates hundreds of calculated columns for values that can be computed in source SQL. Which action addresses the primary cause?
Explanation
Correct Answer
Model size and refresh work may fall when unnecessary calculated columns are removed. The recommended action directly addresses the stated requirement.
Incorrect Answers
This action is appropriate when a model uses bidirectional filters on every relationship and reports contain ambiguous results. Relationship design affects both query work and analytical correctness. However, the question instead requires Consider source-side materialization or reusable measures based on intended semantics. because model size and refresh work may fall when unnecessary calculated columns are removed.
This action is appropriate when a model consumes high memory during refresh and the team assumes adding a second report page will solve it. Data model memory pressure cannot be fixed by a cosmetic change to report layout. However, the question instead requires Consider source-side materialization or reusable measures based on intended semantics. because model size and refresh work may fall when unnecessary calculated columns are removed.
This action is appropriate when a semantic model stores transaction GUIDs in multiple high-cardinality string columns that reports never use. Wide high-cardinality data can consume memory without adding analytical value. However, the question instead requires Consider source-side materialization or reusable measures based on intended semantics. because model size and refresh work may fall when unnecessary calculated columns are removed.






Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests