100% Latest & Updated Microsoft PL-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 220
A report needs a helper table containing only unique combinations of Store and Region. A specific ongoing problem has appeared: Calculated-table values do not update from slicers in the same way as measures. Which safeguard most directly addresses it?
- Document relationship direction decisions and validate new paths.
- Use last available snapshot rather than assuming every month end has a row.
- Use measures for dynamic filter-context results instead of stored tables.
- Optimize row grain and avoid repeated costly iterator work.
Explanation
Correct Answer
C:Choose an object type that matches the required evaluation time.
Incorrect Answers
A:Maintaining a clear model prevents regressions; choose an object type that matches the required evaluation time.
B:Semi-additive measures must handle missing snapshot days. Choose an object type that matches the required evaluation time.
D:Iterators may be more expensive than simple storage-engine aggregations. Choose an object type that matches the required evaluation time.
Question 221
A product dimension is duplicated after a join because its source includes historical versions per product. Which Power BI approach most directly satisfies this requirement?
- Set measure format strings rather than converting numerical values to text.
- Choose a dimension key at the model's intended historical grain.
- Resolve ambiguous relationship paths rather than enabling every filter direction.
- Create a proper date table and mark it for time intelligence as appropriate.
Explanation
Correct Answer
B:A business ID alone is not unique when versioned dimension rows exist.
Incorrect Answers
A:A formatted numeric measure remains usable in sorting and arithmetic. A business ID alone is not unique when versioned dimension rows exist.
C:Multiple active paths can yield unexpected filter propagation. A business ID alone is not unique when versioned dimension rows exist.
D:A contiguous calendar with a date column supports reliable time calculations; a business ID alone is not unique when versioned dimension rows exist.
Question 222
A dimension imported from a slowly changing source has several effective-dated records per business ID. The selected approach is: Choose a dimension key at the model's intended historical grain. Which implementation step puts it into practice?
- Use CALCULATE with USERELATIONSHIP on the intended date columns.
- Document a unique row key and use grain-consistent measures.
- Create separate labeled date table roles or an inactive alternate relation.
- Use a surrogate version key or apply an explicit current-record rule.
Explanation
Correct Answer
D:Relationships must not use nonunique versioned IDs as the one-side key.
Incorrect Answers
A:This changes the date filtering of that measure without making both relationships globally active. It does not implement the needed solution: choose a dimension key at the model's intended historical grain.
B:Measures such as order count may require DISTINCTCOUNT of an order identifier. It does not implement the needed solution: choose a dimension key at the model's intended historical grain.
C:The design must distinguish the date used to filter each measure. It does not implement the needed solution: choose a dimension key at the model's intended historical grain.
Question 223
A product dimension is duplicated after a join because its source includes historical versions per product. The chosen solution is: Choose a dimension key at the model's intended historical grain. Which verification best demonstrates that it meets the requirement?
- Test historical and current joins for correct transaction attribution.
- Compare values and query duration under representative filters.
- Change slicers and verify ranks recalculate among the intended stores.
- Inspect query folding and compare refresh time after the change.
Explanation
Correct Answer
A:The model should match the appropriate version or current value.
Incorrect Answers
B:An optimization must preserve totals and improve speed. That check does not verify the result required here: test historical and current joins for correct transaction attribution.
C:Rank 1 should match the highest measure within scope. That check does not verify the result required here: test historical and current joins for correct transaction attribution.
D:Folded filters should improve refresh efficiency. That check does not verify the result required here: test historical and current joins for correct transaction attribution.
Question 224
A product dimension is duplicated after a join because its source includes historical versions per product. A specific ongoing problem has appeared: A source change might add another historical record for the same ID. Which safeguard most directly addresses it?
- Test format strings and precedence across report visuals.
- Use comparable filter and cache conditions for performance testing.
- Validate uniqueness at the chosen effective-dated key.
- Optimize row grain and avoid repeated costly iterator work.
Explanation
Correct Answer
C:Versioned dimensions require consistent key strategy.
Incorrect Answers
A:Calculation items can affect evaluation and presentation order; versioned dimensions require consistent key strategy.
B:Performance results need consistent test scenarios. Versioned dimensions require consistent key strategy.
D:Iterators may be more expensive than simple storage-engine aggregations. Versioned dimensions require consistent key strategy.
Question 225
An analyst uses one field table for Sales by Month and Product but needs a distinct Date dimension for time slicing. Which Power BI approach most directly satisfies this requirement?
- Separate timestamp fact data from a consistent date dimension.
- Resolve ambiguous relationship paths rather than enabling every filter direction.
- Use a calculated table when a materialized model table is justified.
- Activate an alternate relationship inside a specific DAX measure.
Explanation
Correct Answer
A:Date hierarchy semantics benefit from a reusable calendar.
Incorrect Answers
B:Multiple active paths can yield unexpected filter propagation; date hierarchy semantics benefit from a reusable calendar.
C:Calculated tables are computed during processing and then stored. Date hierarchy semantics benefit from a reusable calendar.
D:USERELATIONSHIP can select an inactive relationship within a CALCULATE expression; date hierarchy semantics benefit from a reusable calendar.
Question 226
An operations report has a raw datetime field with timestamps but must compare days and weeks. The selected approach is: Separate timestamp fact data from a consistent date dimension. Which implementation step puts it into practice?
- Create a date-only relationship key and relate to a date table.
- Apply currency or percentage format to the correct model measure.
- Document a unique row key and use grain-consistent measures.
- Hide surrogate keys and set appropriate categories, names and formatting.
Explanation
Correct Answer
A:A timestamp including hours is not an exact date-only join key.
Incorrect Answers
B:Formatting should not alter the measure's numeric data type. It does not implement the needed solution: separate timestamp fact data from a consistent date dimension.
C:Measures such as order count may require DISTINCTCOUNT of an order identifier. It does not implement the needed solution: separate timestamp fact data from a consistent date dimension.
D:The fields pane should emphasize business-friendly measures. It does not implement the needed solution: separate timestamp fact data from a consistent date dimension.
Question 227
An analyst uses one field table for Sales by Month and Product but needs a distinct Date dimension for time slicing. The chosen solution is: Separate timestamp fact data from a consistent date dimension. Which THREE actions together select the solution, put it into practice, and verify its result? Choose THREE.
- Resolve ambiguous relationship paths rather than enabling every filter direction.
- Compare values and query duration under representative filters.
- Apply currency or percentage format to the correct model measure.
- Separate timestamp fact data from a consistent date dimension.
- Create a date-only relationship key and relate to a date table.
- Verify each fact row maps to the expected calendar day.
Explanation
Correct Answers
D:Date hierarchy semantics benefit from a reusable calendar.
E:A timestamp including hours is not an exact date-only join key.
F:Date joins must preserve correct day boundaries.
Incorrect Answers
A:Multiple active paths can yield unexpected filter propagation. Date hierarchy semantics benefit from a reusable calendar.
B:An optimization must preserve totals and improve speed. That check does not verify the result required here: verify each fact row maps to the expected calendar day.
C:Formatting should not alter the measure's numeric data type. It does not implement the needed solution: separate timestamp fact data from a consistent date dimension.
Question 228
An analyst uses one field table for Sales by Month and Product but needs a distinct Date dimension for time slicing. A specific ongoing problem has appeared: Timezone changes can shift timestamps across dates. Which safeguard most directly addresses it?
- Normalize timestamp zones before deriving date keys.
- Validate filter-context assumptions around variables.
- Use comparable filter and cache conditions for performance testing.
- Keep a governed detailed source separately if deeper drilldown is required.
Explanation
Correct Answer
A:A consistent reporting timezone avoids off-by-one dates.
Incorrect Answers
B:Moving a variable can change evaluation semantics. A consistent reporting timezone avoids off-by-one dates.
C:Performance results need consistent test scenarios; a consistent reporting timezone avoids off-by-one dates.
D:Granularity reduction trades detail for performance. A consistent reporting timezone avoids off-by-one dates.
Question 229
A model has two alternative filter routes between Customer and Sales, producing confusing totals. Which Power BI approach most directly satisfies this requirement?
- Resolve ambiguous relationship paths rather than enabling every filter direction.
- Use a calculated column when a stored row attribute is needed.
- Connect multiple fact tables through conformed dimensions.
- Hide technical columns and provide clear measure/field properties.
Explanation
Correct Answer
A:Multiple active paths can yield unexpected filter propagation.
Incorrect Answers
B:Calculated columns materialize per-row results in the model, unlike measures evaluated on demand; multiple active paths can yield unexpected filter propagation.
C:Shared dimensions support consistent slicing of separate fact grains. Multiple active paths can yield unexpected filter propagation.
D:Metadata design helps authors use intended business fields; multiple active paths can yield unexpected filter propagation.
Question 230
A report's cross-filter design becomes ambiguous after adding a new relationship. The selected approach is: Resolve ambiguous relationship paths rather than enabling every filter direction. Which implementation step puts it into practice?
- Create distinct dimension keys and a relationship bridge at assignment grain.
- Disable or refactor conflicting paths and use explicit measure context where needed.
- Use CALCULATE with USERELATIONSHIP on the intended date columns.
- Define the DAX table expression and establish appropriate relationships.
Explanation
Correct Answer
B:Each measure should have an intended unambiguous filter route.
Incorrect Answers
A:The bridge should contain the intended association rows. It does not implement the needed solution: resolve ambiguous relationship paths rather than enabling every filter direction.
C:This changes the date filtering of that measure without making both relationships globally active. It does not implement the needed solution: resolve ambiguous relationship paths rather than enabling every filter direction.
D:A calculated table needs valid keys and load-time semantics. It does not implement the needed solution: resolve ambiguous relationship paths rather than enabling every filter direction.
Microsoft Power BI Data Analyst (PL-300) Practice Tests