Question 480
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A calculation item should operate on the currently selected base measure rather than a hard-coded revenue measure. (2) A model has multiple calculation groups whose ordering creates unexpected results. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use SELECTEDMEASURE in the calculation item expression. | (2) Review calculation group precedence and test combined selections.
- (1) Create a supported calculation group with reusable time-intelligence calculation items. | (2) Review calculation group precedence and test combined selections.
- (1) Use SELECTEDMEASURE in the calculation item expression. | (2) Define an appropriate format-string expression for the calculation item.
- (1) Use a supported model-editing workflow and verify calculation-group prerequisites. | (2) Review calculation group precedence and test combined selections.
Explanation
Correct Answer
A:Requirement 1: SELECTEDMEASURE makes a calculation reusable across eligible measures. Requirement 2: Precedence controls how multiple calculation-item expressions are composed. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: SELECTEDMEASURE makes a calculation reusable across eligible measures. The substituted action, Create a supported calculation group with reusable time-intelligence calculation items., is suited to a different situation: A large model repeats year-to-date, prior-year and growth calculations for dozens of base measures. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Precedence controls how multiple calculation-item expressions are composed. The substituted action, Define an appropriate format-string expression for the calculation item., is suited to a different situation: A calculation group changes a decimal KPI to a whole number in every report. It does not satisfy the specified requirement 2.
D:Misses requirement 1: SELECTEDMEASURE makes a calculation reusable across eligible measures. The substituted action, Use a supported model-editing workflow and verify calculation-group prerequisites., is suited to a different situation: A team tries to create calculation groups without checking the model editing tool and compatibility. It does not satisfy the specified requirement 1.
Question 481
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A measure uses DAX FORMAT to display currency and downstream charts stop treating its result as numeric. (2) A KPI should display a percentage with one decimal without changing its underlying ratio. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Replace text conversion with dynamic format strings when suitable. | (2) Configure calculation-item format strings based on the metric semantics.
- (1) Keep measures numeric and use semantic model formatting metadata. | (2) Apply the correct percentage measure format rather than multiplying stored values arbitrarily.
- (1) Replace text conversion with dynamic format strings when suitable. | (2) Apply the correct percentage measure format rather than multiplying stored values arbitrarily.
- (1) Define a supported dynamic format-string expression for the measure. | (2) Apply the correct percentage measure format rather than multiplying stored values arbitrarily.
Explanation
Correct Answer
C:Requirement 1: FORMAT returns text and can break numeric aggregation and sorting. Requirement 2: Formatting expresses numeric semantics while preserving the value. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Formatting expresses numeric semantics while preserving the value. The substituted action, Configure calculation-item format strings based on the metric semantics., is suited to a different situation: An organization wants calculation items to show percent growth and currency totals with distinct formats. It does not satisfy the specified requirement 2.
B:Misses requirement 1: FORMAT returns text and can break numeric aggregation and sorting. The substituted action, Keep measures numeric and use semantic model formatting metadata., is suited to a different situation: A report's currency format changes but exported numeric values must remain suitable for calculations. It does not satisfy the specified requirement 1.
D:Misses requirement 1: FORMAT returns text and can break numeric aggregation and sorting. The substituted action, Define a supported dynamic format-string expression for the measure., is suited to a different situation: The same revenue measure must show euros for one currency selection and dollars for another. It does not satisfy the specified requirement 1.
Question 482
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A user needs to toggle between revenue, profit and quantity in one visual. (2) A field parameter references an unapproved sensitive dimension and users can expose it in a visual. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use a field parameter containing the intended measures. | (2) Restrict the field parameter to fields authorized for the target audience.
- (1) Create a supported field parameter that includes the approved dimension fields. | (2) Restrict the field parameter to fields authorized for the target audience.
- (1) Use a field parameter containing the intended measures. | (2) Explain that field parameters modify semantic or visual field selection, not source data.
- (1) Test dependent visuals, slicers and bookmarks when modifying parameter definitions. | (2) Restrict the field parameter to fields authorized for the target audience.
Explanation
Correct Answer
A:Requirement 1: Measure parameters can switch the metric without duplicating whole report pages. Requirement 2: Dynamic selection should not introduce new access to confidential attributes. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Measure parameters can switch the metric without duplicating whole report pages. The substituted action, Create a supported field parameter that includes the approved dimension fields., is suited to a different situation: A report consumer wants to switch a chart axis between product, region and channel. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Dynamic selection should not introduce new access to confidential attributes. The substituted action, Explain that field parameters modify semantic or visual field selection, not source data., is suited to a different situation: An analyst expects a field parameter to rewrite the underlying data warehouse table. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Measure parameters can switch the metric without duplicating whole report pages. The substituted action, Test dependent visuals, slicers and bookmarks when modifying parameter definitions., is suited to a different situation: A field parameter is renamed and bookmarked report states no longer restore correctly. It does not satisfy the specified requirement 1.
Question 483
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A model grows beyond standard storage assumptions and needs enterprise-scale capacity features. (2) A team enables large model format and assumes it automatically fixes inefficient DAX. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Evaluate large semantic model storage format and capacity prerequisites. | (2) Validate storage-mode compatibility before designing the composite structure.
- (1) Review cross-source relationship behavior and test query semantics for the chosen modes. | (2) Profile measures and relationships independently of model storage settings.
- (1) Evaluate large semantic model storage format and capacity prerequisites. | (2) Profile measures and relationships independently of model storage settings.
- (1) Build an eligible composite model with supported Import and DirectQuery storage modes. | (2) Profile measures and relationships independently of model storage settings.
Explanation
Correct Answer
C:Requirement 1: Large storage configurations can support eligible enterprise-scale models when properly provisioned. Requirement 2: Storage capacity does not replace query and model optimization. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Storage capacity does not replace query and model optimization. The substituted action, Validate storage-mode compatibility before designing the composite structure., is suited to a different situation: An architect mixes Direct Lake on SQL tables with unsupported additional storage modes in one model. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Large storage configurations can support eligible enterprise-scale models when properly provisioned. The substituted action, Review cross-source relationship behavior and test query semantics for the chosen modes., is suited to a different situation: A composite model builds a relationship across Import and DirectQuery sources and totals unexpectedly change. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Large storage configurations can support eligible enterprise-scale models when properly provisioned. The substituted action, Build an eligible composite model with supported Import and DirectQuery storage modes., is suited to a different situation: A semantic model must combine a small imported budget table with a live sales source. It does not satisfy the specified requirement 1.
Question 484
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A dashboard becomes slow only when a specific slicer produces many high-cardinality groups. (2) A report loads quickly in Desktop but is slow under production capacity concurrency. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Reduce unnecessary visual detail and inspect the query produced under that filter. | (2) Compare capacity utilization and simultaneous model-query load during the slowdown.
- (1) Use Power BI Performance Analyzer to inspect the slow visual's query timing. | (2) Compare capacity utilization and simultaneous model-query load during the slowdown.
- (1) Reduce unnecessary visual detail and inspect the query produced under that filter. | (2) Benchmark the visual rendering cost separately from DAX query time.
- (1) Simplify visual interactions and avoid unnecessary duplicated calculations. | (2) Compare capacity utilization and simultaneous model-query load during the slowdown.
Explanation
Correct Answer
A:Requirement 1: Visual cardinality can multiply both rendering and model-query work. Requirement 2: Production concurrency can expose limits not seen in isolated development testing. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Visual cardinality can multiply both rendering and model-query work. The substituted action, Use Power BI Performance Analyzer to inspect the slow visual's query timing., is suited to a different situation: A report contains one visual that loads much more slowly than adjacent visuals. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Production concurrency can expose limits not seen in isolated development testing. The substituted action, Benchmark the visual rendering cost separately from DAX query time., is suited to a different situation: An analyst adds a complex custom visual and total page render time rises despite unchanged measures. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Visual cardinality can multiply both rendering and model-query work. The substituted action, Simplify visual interactions and avoid unnecessary duplicated calculations., is suited to a different situation: A page has dozens of visuals issuing redundant queries every time a slicer changes. It does not satisfy the specified requirement 1.
Question 485
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A margin KPI calculates row-wise ratio then sums it, causing numerical inconsistency and high query work. (2) A DAX formula recomputes the same large table expression several times. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Replace the design with ratio of appropriately aggregated numerator and denominator. | (2) Use native numeric measures with dynamic format strings or model formats.
- (1) Correct the denominator filter scope using the intended peer set. | (2) Cache an intermediate expression with VAR and inspect the resulting execution plan.
- (1) Replace the design with ratio of appropriately aggregated numerator and denominator. | (2) Cache an intermediate expression with VAR and inspect the resulting execution plan.
- (1) Rewrite CALCULATE filters to use efficient column predicates where semantics permit. | (2) Cache an intermediate expression with VAR and inspect the resulting execution plan.
Explanation
Correct Answer
C:Requirement 1: Correct aggregate semantics can also eliminate excessive per-row iteration. Requirement 2: Variables can reduce repeated evaluation and make performance investigation easier. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Variables can reduce repeated evaluation and make performance investigation easier. The substituted action, Use native numeric measures with dynamic format strings or model formats., is suited to a different situation: A report uses `FORMAT` on every numeric measure and sorting and charts behave as text. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Correct aggregate semantics can also eliminate excessive per-row iteration. The substituted action, Correct the denominator filter scope using the intended peer set., is suited to a different situation: A visual displays every store's percentage as 100% and a measure has an overbroad ALL call. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Correct aggregate semantics can also eliminate excessive per-row iteration. The substituted action, Rewrite CALCULATE filters to use efficient column predicates where semantics permit., is suited to a different situation: A DAX measure iterates a billion-row fact using FILTER even though a simple column predicate would suffice. It does not satisfy the specified requirement 1.
Question 486
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A semantic model references a nonmaterialized SQL view and reports are slower than Delta-table queries. (2) A Fabric capacity has Direct Lake table sizes above guardrail thresholds and fallback occurs. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Evaluate materializing the view as a Delta table or accepting DirectQuery fallback. | (2) Review capacity guardrails and optimize Delta files or scale capacity as warranted.
- (1) Inspect SQL endpoint RLS and DirectQuery fallback behavior for the affected table. | (2) Review capacity guardrails and optimize Delta files or scale capacity as warranted.
- (1) Evaluate materializing the view as a Delta table or accepting DirectQuery fallback. | (2) Reevaluate DirectLakeBehavior settings and remove the incompatible dependency or reenable supported fallback.
- (1) Inspect supported Direct Lake query diagnostics such as TABLETRAITS fallback information. | (2) Review capacity guardrails and optimize Delta files or scale capacity as warranted.
Explanation
Correct Answer
A:Requirement 1: Views in Direct Lake on SQL can require query fallback instead of reading Delta columns directly. Requirement 2: Excessive file counts or row groups can make in-memory Direct Lake queries ineligible. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Views in Direct Lake on SQL can require query fallback instead of reading Delta columns directly. The substituted action, Inspect SQL endpoint RLS and DirectQuery fallback behavior for the affected table., is suited to a different situation: A Direct Lake on SQL model unexpectedly switches slow report queries to SQL for a secured source table. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Excessive file counts or row groups can make in-memory Direct Lake queries ineligible. The substituted action, Reevaluate DirectLakeBehavior settings and remove the incompatible dependency or reenable supported fallback., is suited to a different situation: A team disables fallback while keeping SQL security constraints that need it, and visuals fail. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Views in Direct Lake on SQL can require query fallback instead of reading Delta columns directly. The substituted action, Inspect supported Direct Lake query diagnostics such as TABLETRAITS fallback information., is suited to a different situation: A report owner cannot explain whether Direct Lake used in-memory columns or SQL fallback. It does not satisfy the specified requirement 1.
Question 487
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A model requires SQL analytics endpoint security semantics and may accept slower queries when restricted. (2) A team expects Direct Lake on OneLake to fall back to DirectQuery when its guardrails are exceeded. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Evaluate Direct Lake on SQL analytics endpoints with documented fallback behavior. | (2) Check Direct Lake on OneLake source integration and permission requirements.
- (1) Configure and verify OneLake security or semantic-model RLS for that model. | (2) Explain that Direct Lake on OneLake does not support DirectQuery fallback.
- (1) Evaluate Direct Lake on SQL analytics endpoints with documented fallback behavior. | (2) Explain that Direct Lake on OneLake does not support DirectQuery fallback.
- (1) Select Direct Lake on OneLake where the source and capacity meet requirements. | (2) Explain that Direct Lake on OneLake does not support DirectQuery fallback.
Explanation
Correct Answer
C:Requirement 1: This variant checks SQL-endpoint metadata and may execute DirectQuery for restricted paths. Requirement 2: Unsupported direct lake execution fails rather than silently switching to SQL in the OneLake variant. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Unsupported direct lake execution fails rather than silently switching to SQL in the OneLake variant. The substituted action, Check Direct Lake on OneLake source integration and permission requirements., is suited to a different situation: A designer wants a single Direct Lake model to span eligible Delta sources rather than only one SQL endpoint. It does not satisfy the specified requirement 2.
B:Misses requirement 1: This variant checks SQL-endpoint metadata and may execute DirectQuery for restricted paths. The substituted action, Configure and verify OneLake security or semantic-model RLS for that model., is suited to a different situation: An analyst assumes SQL endpoint row security automatically protects a Direct Lake on OneLake model. It does not satisfy the specified requirement 1.
D:Misses requirement 1: This variant checks SQL-endpoint metadata and may execute DirectQuery for restricted paths. The substituted action, Select Direct Lake on OneLake where the source and capacity meet requirements., is suited to a different situation: A new semantic model needs direct Delta-column access with OneLake security but no SQL endpoint dependency. It does not satisfy the specified requirement 1.
Question 488
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A team confuses Direct Lake semantic refresh with a full copy of all tables into Import storage. (2) A Direct Lake model has automatic updates disabled but business users expect newly committed Delta data immediately. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Explain that Direct Lake refresh typically updates framing metadata rather than importing all source rows. | (2) Configure approved automatic updates or a refresh trigger aligned with the freshness SLA.
- (1) Check model framing or automatic updates and trigger a supported refresh when needed. | (2) Configure approved automatic updates or a refresh trigger aligned with the freshness SLA.
- (1) Explain that Direct Lake refresh typically updates framing metadata rather than importing all source rows. | (2) Perform an appropriate model refresh after adding the table definition.
- (1) Refresh affected models and revalidate effective security as required by the integration. | (2) Configure approved automatic updates or a refresh trigger aligned with the freshness SLA.
Explanation
Correct Answer
A:Requirement 1: Framing tracks eligible Delta table snapshots while columns are read on demand. Requirement 2: Source commits alone do not override a disabled model framing policy. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Framing tracks eligible Delta table snapshots while columns are read on demand. The substituted action, Check model framing or automatic updates and trigger a supported refresh when needed., is suited to a different situation: A Direct Lake report still shows prior values after upstream Delta rows changed. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Source commits alone do not override a disabled model framing policy. The substituted action, Perform an appropriate model refresh after adding the table definition., is suited to a different situation: A model adds a table through XMLA metadata and its report returns an unframed-table error. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Framing tracks eligible Delta table snapshots while columns are read on demand. The substituted action, Refresh affected models and revalidate effective security as required by the integration., is suited to a different situation: A data steward modifies OneLake security roles and a Direct Lake model still evaluates old access assumptions. It does not satisfy the specified requirement 1.
Question 489
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) An incremental refresh policy produces duplicate data because partitions overlap at the time boundary. (2) A model defines incremental refresh but the source query does not fold the date predicate. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Use a consistent inclusive lower and exclusive upper bound on partition filters. | (2) Extend the refresh policy or schedule a controlled historical reprocessing operation.
- (1) Verify service-side policy application and scheduled incremental refresh execution. | (2) Inspect query folding and push eligible date filters to the source.
- (1) Use a consistent inclusive lower and exclusive upper bound on partition filters. | (2) Inspect query folding and push eligible date filters to the source.
- (1) Configure supported incremental refresh with RangeStart and RangeEnd partitions. | (2) Inspect query folding and push eligible date filters to the source.
Explanation
Correct Answer
C:Requirement 1: Nonoverlapping partition predicates prevent duplicate boundary rows. Requirement 2: Without effective folding, every partition may rescan full source data. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 2: Without effective folding, every partition may rescan full source data. The substituted action, Extend the refresh policy or schedule a controlled historical reprocessing operation., is suited to a different situation: Late-arriving corrections change older partitions beyond the refresh window. It does not satisfy the specified requirement 2.
B:Misses requirement 1: Nonoverlapping partition predicates prevent duplicate boundary rows. The substituted action, Verify service-side policy application and scheduled incremental refresh execution., is suited to a different situation: A published model's refresh policy is configured but only historical partitions are being processed manually. It does not satisfy the specified requirement 1.
D:Misses requirement 1: Nonoverlapping partition predicates prevent duplicate boundary rows. The substituted action, Configure supported incremental refresh with RangeStart and RangeEnd partitions., is suited to a different situation: A ten-year Import semantic model takes hours to reload even though only the most recent month changes. It does not satisfy the specified requirement 1.
Question 490
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A fact table includes a verbose description repeated across millions of rows. (2) A model creates hundreds of calculated columns for values that can be computed in source SQL. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Move stable descriptions to an appropriate dimension when relationships support it. | (2) Consider source-side materialization or reusable measures based on intended semantics.
- (1) Remove unneeded high-cardinality columns from the model. | (2) Consider source-side materialization or reusable measures based on intended semantics.
- (1) Move stable descriptions to an appropriate dimension when relationships support it. | (2) Simplify to a clear star schema with controlled filter directions.
- (1) Profile model tables, cardinality and capacity usage before sizing or redesigning. | (2) Consider source-side materialization or reusable measures based on intended semantics.
Explanation
Correct Answer
A:Requirement 1: Dimensional normalization can reduce repeated text and improve compression. Requirement 2: Model size and refresh work may fall when unnecessary calculated columns are removed. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
B:Misses requirement 1: Dimensional normalization can reduce repeated text and improve compression. The substituted action, Remove unneeded high-cardinality columns from the model., is suited to a different situation: A semantic model stores transaction GUIDs in multiple high-cardinality string columns that reports never use. It does not satisfy the specified requirement 1.
C:Misses requirement 2: Model size and refresh work may fall when unnecessary calculated columns are removed. The substituted action, Simplify to a clear star schema with controlled filter directions., is suited to a different situation: A model uses bidirectional filters on every relationship and reports contain ambiguous results. It does not satisfy the specified requirement 2.
D:Misses requirement 1: Dimensional normalization can reduce repeated text and improve compression. The substituted action, Profile model tables, cardinality and capacity usage before sizing or redesigning., is suited to a different situation: A model consumes high memory during refresh and the team assumes adding a second report page will solve it. It does not satisfy the specified requirement 1.
Implementing Analytics Solutions Using Microsoft Fabric (DP-600) Practice Tests