Question 410
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A large model repeats year-to-date, prior-year and growth calculations for dozens of base measures. (2) A calculation item should operate on the currently selected base measure rather than a hard-coded revenue measure. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Review calculation group precedence and test combined selections. | (2) Use SELECTEDMEASURE in the calculation item expression.
- (1) Create a supported calculation group with reusable time-intelligence calculation items. | (2) Define an appropriate format-string expression for the calculation item.
- (1) Use a supported model-editing workflow and verify calculation-group prerequisites. | (2) Use SELECTEDMEASURE in the calculation item expression.
- (1) Create a supported calculation group with reusable time-intelligence calculation items. | (2) Use SELECTEDMEASURE in the calculation item expression.
Explanation
Correct Answer
D:Requirement 1: Calculation groups reduce repeated measure patterns by transforming selected measures. Requirement 2: SELECTEDMEASURE makes a calculation reusable across eligible measures. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Calculation groups reduce repeated measure patterns by transforming selected measures. The substituted action, Review calculation group precedence and test combined selections., is suited to a different situation: A model has multiple calculation groups whose ordering creates unexpected results. It does not satisfy the specified requirement 1.
B:Misses requirement 2: SELECTEDMEASURE makes a calculation reusable across eligible measures. 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.
C:Misses requirement 1: Calculation groups reduce repeated measure patterns by transforming selected 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 411
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) The same revenue measure must show euros for one currency selection and dollars for another. (2) A measure uses DAX FORMAT to display currency and downstream charts stop treating its result as numeric. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Keep measures numeric and use semantic model formatting metadata. | (2) Replace text conversion with dynamic format strings when suitable.
- (1) Define a supported dynamic format-string expression for the measure. | (2) Replace text conversion with dynamic format strings when suitable.
- (1) Apply the correct percentage measure format rather than multiplying stored values arbitrarily. | (2) Replace text conversion with dynamic format strings when suitable.
- (1) Define a supported dynamic format-string expression for the measure. | (2) Configure calculation-item format strings based on the metric semantics.
Explanation
Correct Answer
B:Requirement 1: Dynamic formatting changes presentation without converting the numeric measure to text. Requirement 2: FORMAT returns text and can break numeric aggregation and sorting. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Dynamic formatting changes presentation without converting the numeric measure to text. 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.
C:Misses requirement 1: Dynamic formatting changes presentation without converting the numeric measure to text. The substituted action, Apply the correct percentage measure format rather than multiplying stored values arbitrarily., is suited to a different situation: A KPI should display a percentage with one decimal without changing its underlying ratio. It does not satisfy the specified requirement 1.
D:Misses requirement 2: FORMAT returns text and can break numeric aggregation and sorting. 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.
Question 412
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A report consumer wants to switch a chart axis between product, region and channel. (2) A user needs to toggle between revenue, profit and quantity in one visual. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Restrict the field parameter to fields authorized for the target audience. | (2) Use a field parameter containing the intended measures.
- (1) Create a supported field parameter that includes the approved dimension fields. | (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) Use a field parameter containing the intended measures.
- (1) Create a supported field parameter that includes the approved dimension fields. | (2) Use a field parameter containing the intended measures.
Explanation
Correct Answer
D:Requirement 1: Field parameters provide user-controlled selection among model fields. Requirement 2: Measure parameters can switch the metric without duplicating whole report pages. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Field parameters provide user-controlled selection among model fields. The substituted action, Restrict the field parameter to fields authorized for the target audience., is suited to a different situation: A field parameter references an unapproved sensitive dimension and users can expose it in a visual. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Measure parameters can switch the metric without duplicating whole report pages. 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.
C:Misses requirement 1: Field parameters provide user-controlled selection among model fields. 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 413
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A semantic model must combine a small imported budget table with a live sales source. (2) A model grows beyond standard storage assumptions and needs enterprise-scale capacity features. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Review cross-source relationship behavior and test query semantics for the chosen modes. | (2) Evaluate large semantic model storage format and capacity prerequisites.
- (1) Build an eligible composite model with supported Import and DirectQuery storage modes. | (2) Evaluate large semantic model storage format and capacity prerequisites.
- (1) Profile measures and relationships independently of model storage settings. | (2) Evaluate large semantic model storage format and capacity prerequisites.
- (1) Build an eligible composite model with supported Import and DirectQuery storage modes. | (2) Validate storage-mode compatibility before designing the composite structure.
Explanation
Correct Answer
B:Requirement 1: Mixed storage models allow different freshness and performance tradeoffs per table. Requirement 2: Large storage configurations can support eligible enterprise-scale models when properly provisioned. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Mixed storage models allow different freshness and performance tradeoffs per table. 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.
C:Misses requirement 1: Mixed storage models allow different freshness and performance tradeoffs per table. The substituted action, Profile measures and relationships independently of model storage settings., is suited to a different situation: A team enables large model format and assumes it automatically fixes inefficient DAX. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Large storage configurations can support eligible enterprise-scale models when properly provisioned. 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.
Question 414
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A report contains one visual that loads much more slowly than adjacent visuals. (2) A dashboard becomes slow only when a specific slicer produces many high-cardinality groups. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Compare capacity utilization and simultaneous model-query load during the slowdown. | (2) Reduce unnecessary visual detail and inspect the query produced under that filter.
- (1) Use Power BI Performance Analyzer to inspect the slow visual's query timing. | (2) Benchmark the visual rendering cost separately from DAX query time.
- (1) Simplify visual interactions and avoid unnecessary duplicated calculations. | (2) Reduce unnecessary visual detail and inspect the query produced under that filter.
- (1) Use Power BI Performance Analyzer to inspect the slow visual's query timing. | (2) Reduce unnecessary visual detail and inspect the query produced under that filter.
Explanation
Correct Answer
D:Requirement 1: Visual-level timings help isolate the bottleneck before modifying unrelated model components. Requirement 2: Visual cardinality can multiply both rendering and model-query work. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Visual-level timings help isolate the bottleneck before modifying unrelated model components. The substituted action, Compare capacity utilization and simultaneous model-query load during the slowdown., is suited to a different situation: A report loads quickly in Desktop but is slow under production capacity concurrency. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Visual cardinality can multiply both rendering and model-query work. 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.
C:Misses requirement 1: Visual-level timings help isolate the bottleneck before modifying unrelated model components. 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 415
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A DAX measure iterates a billion-row fact using FILTER even though a simple column predicate would suffice. (2) A margin KPI calculates row-wise ratio then sums it, causing numerical inconsistency and high query work. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Correct the denominator filter scope using the intended peer set. | (2) Replace the design with ratio of appropriately aggregated numerator and denominator.
- (1) Rewrite CALCULATE filters to use efficient column predicates where semantics permit. | (2) Replace the design with ratio of appropriately aggregated numerator and denominator.
- (1) Cache an intermediate expression with VAR and inspect the resulting execution plan. | (2) Replace the design with ratio of appropriately aggregated numerator and denominator.
- (1) Rewrite CALCULATE filters to use efficient column predicates where semantics permit. | (2) Use native numeric measures with dynamic format strings or model formats.
Explanation
Correct Answer
B:Requirement 1: Simpler native filter expressions can lower Formula Engine work. Requirement 2: Correct aggregate semantics can also eliminate excessive per-row iteration. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Simpler native filter expressions can lower Formula Engine work. 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.
C:Misses requirement 1: Simpler native filter expressions can lower Formula Engine work. The substituted action, Cache an intermediate expression with VAR and inspect the resulting execution plan., is suited to a different situation: A DAX formula recomputes the same large table expression several times. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Correct aggregate semantics can also eliminate excessive per-row iteration. 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.
Question 416
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A Direct Lake on SQL model unexpectedly switches slow report queries to SQL for a secured source table. (2) A semantic model references a nonmaterialized SQL view and reports are slower than Delta-table queries. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Review capacity guardrails and optimize Delta files or scale capacity as warranted. | (2) Evaluate materializing the view as a Delta table or accepting DirectQuery fallback.
- (1) Inspect SQL endpoint RLS and DirectQuery fallback behavior for the affected table. | (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) Evaluate materializing the view as a Delta table or accepting DirectQuery fallback.
- (1) Inspect SQL endpoint RLS and DirectQuery fallback behavior for the affected table. | (2) Evaluate materializing the view as a Delta table or accepting DirectQuery fallback.
Explanation
Correct Answer
D:Requirement 1: SQL-endpoint row restrictions can force DirectQuery fallback in this Direct Lake variant. Requirement 2: Views in Direct Lake on SQL can require query fallback instead of reading Delta columns directly. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: SQL-endpoint row restrictions can force DirectQuery fallback in this Direct Lake variant. The substituted action, Review capacity guardrails and optimize Delta files or scale capacity as warranted., is suited to a different situation: A Fabric capacity has Direct Lake table sizes above guardrail thresholds and fallback occurs. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Views in Direct Lake on SQL can require query fallback instead of reading Delta columns directly. 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.
C:Misses requirement 1: SQL-endpoint row restrictions can force DirectQuery fallback in this Direct Lake variant. 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 417
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A new semantic model needs direct Delta-column access with OneLake security but no SQL endpoint dependency. (2) A model requires SQL analytics endpoint security semantics and may accept slower queries when restricted. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Configure and verify OneLake security or semantic-model RLS for that model. | (2) Evaluate Direct Lake on SQL analytics endpoints with documented fallback behavior.
- (1) Select Direct Lake on OneLake where the source and capacity meet requirements. | (2) Evaluate Direct Lake on SQL analytics endpoints with documented fallback behavior.
- (1) Explain that Direct Lake on OneLake does not support DirectQuery fallback. | (2) Evaluate Direct Lake on SQL analytics endpoints with documented fallback behavior.
- (1) Select Direct Lake on OneLake where the source and capacity meet requirements. | (2) Check Direct Lake on OneLake source integration and permission requirements.
Explanation
Correct Answer
B:Requirement 1: The OneLake variant uses OneLake APIs and is not coupled with the SQL endpoint. Requirement 2: This variant checks SQL-endpoint metadata and may execute DirectQuery for restricted paths. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: The OneLake variant uses OneLake APIs and is not coupled with the SQL endpoint. 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.
C:Misses requirement 1: The OneLake variant uses OneLake APIs and is not coupled with the SQL endpoint. The substituted action, Explain that Direct Lake on OneLake does not support DirectQuery fallback., is suited to a different situation: A team expects Direct Lake on OneLake to fall back to DirectQuery when its guardrails are exceeded. It does not satisfy the specified requirement 1.
D:Misses requirement 2: This variant checks SQL-endpoint metadata and may execute DirectQuery for restricted paths. 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.
Question 418
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A Direct Lake report still shows prior values after upstream Delta rows changed. (2) A team confuses Direct Lake semantic refresh with a full copy of all tables into Import storage. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Configure approved automatic updates or a refresh trigger aligned with the freshness SLA. | (2) Explain that Direct Lake refresh typically updates framing metadata rather than importing all source rows.
- (1) Check model framing or automatic updates and trigger a supported refresh when needed. | (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) Explain that Direct Lake refresh typically updates framing metadata rather than importing all source rows.
- (1) Check model framing or automatic updates and trigger a supported refresh when needed. | (2) Explain that Direct Lake refresh typically updates framing metadata rather than importing all source rows.
Explanation
Correct Answer
D:Requirement 1: Model framing determines which Delta table state the semantic model can query. Requirement 2: Framing tracks eligible Delta table snapshots while columns are read on demand. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Model framing determines which Delta table state the semantic model can query. The substituted action, Configure approved automatic updates or a refresh trigger aligned with the freshness SLA., is suited to a different situation: A Direct Lake model has automatic updates disabled but business users expect newly committed Delta data immediately. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Framing tracks eligible Delta table snapshots while columns are read on demand. 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.
C:Misses requirement 1: Model framing determines which Delta table state the semantic model can query. 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 419
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A ten-year Import semantic model takes hours to reload even though only the most recent month changes. (2) An incremental refresh policy produces duplicate data because partitions overlap at the time boundary. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Verify service-side policy application and scheduled incremental refresh execution. | (2) Use a consistent inclusive lower and exclusive upper bound on partition filters.
- (1) Configure supported incremental refresh with RangeStart and RangeEnd partitions. | (2) Use a consistent inclusive lower and exclusive upper bound on partition filters.
- (1) Inspect query folding and push eligible date filters to the source. | (2) Use a consistent inclusive lower and exclusive upper bound on partition filters.
- (1) Configure supported incremental refresh with RangeStart and RangeEnd partitions. | (2) Extend the refresh policy or schedule a controlled historical reprocessing operation.
Explanation
Correct Answer
B:Requirement 1: Incremental processing reduces refresh work to changed time ranges. Requirement 2: Nonoverlapping partition predicates prevent duplicate boundary rows. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Incremental processing reduces refresh work to changed time ranges. 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.
C:Misses requirement 1: Incremental processing reduces refresh work to changed time ranges. The substituted action, Inspect query folding and push eligible date filters to the source., is suited to a different situation: A model defines incremental refresh but the source query does not fold the date predicate. It does not satisfy the specified requirement 1.
D:Misses requirement 2: Nonoverlapping partition predicates prevent duplicate boundary rows. 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.
Question 420
A Microsoft Fabric analytics team faces 2 concurrent, independent needs in the same workstream: (1) A semantic model stores transaction GUIDs in multiple high-cardinality string columns that reports never use. (2) A fact table includes a verbose description repeated across millions of rows. Which action bundle addresses ALL 2 needs without replacing a required control with a different one?
- (1) Consider source-side materialization or reusable measures based on intended semantics. | (2) Move stable descriptions to an appropriate dimension when relationships support it.
- (1) Remove unneeded high-cardinality columns from the model. | (2) Simplify to a clear star schema with controlled filter directions.
- (1) Profile model tables, cardinality and capacity usage before sizing or redesigning. | (2) Move stable descriptions to an appropriate dimension when relationships support it.
- (1) Remove unneeded high-cardinality columns from the model. | (2) Move stable descriptions to an appropriate dimension when relationships support it.
Explanation
Correct Answer
D:Requirement 1: Wide high-cardinality data can consume memory without adding analytical value. Requirement 2: Dimensional normalization can reduce repeated text and improve compression. Each action is needed for its corresponding requirement; the bundle covers all stated needs.
Incorrect Answers
A:Misses requirement 1: Wide high-cardinality data can consume memory without adding analytical value. The substituted action, Consider source-side materialization or reusable measures based on intended semantics., is suited to a different situation: A model creates hundreds of calculated columns for values that can be computed in source SQL. It does not satisfy the specified requirement 1.
B:Misses requirement 2: Dimensional normalization can reduce repeated text and improve compression. 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.
C:Misses requirement 1: Wide high-cardinality data can consume memory without adding analytical value. 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