100% Latest & Updated Microsoft PL-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 210
A sales and returns model must compare totals by the same customer and date dimensions. The selected approach is: Connect multiple fact tables through conformed dimensions. Which implementation step puts it into practice?
- Relate each fact to the relevant uniquely keyed dimensions.
- Apply currency or percentage format to the correct model measure.
- Build a unique continuous Date column and mark it as the model date table.
- Create the row expression and assign its data type and category.
Explanation
Correct Answer
A:Direct fact-to-fact joins can multiply measures unpredictably.
Incorrect Answers
B:Formatting should not alter the measure's numeric data type. It does not implement the needed solution: connect multiple fact tables through conformed dimensions.
C:Time intelligence relies on correct date semantics and relationships. It does not implement the needed solution: connect multiple fact tables through conformed dimensions.
D:The column must be calculated from appropriate row context. It does not implement the needed solution: connect multiple fact tables through conformed dimensions.
Question 211
Two fact tables share a Product dimension but should not be directly joined row to row. The chosen solution is: Connect multiple fact tables through conformed dimensions. Which verification best demonstrates that it meets the requirement?
- Check the monthly value against the last recorded daily balance.
- Test zero, one and multiple selected values in slicers.
- Compare sales and return totals under common slicers.
- Compare query results and execution characteristics consistently.
Explanation
Correct Answer
C:Shared filters should affect both facts correctly.
Incorrect Answers
A:A sum across dates would overstate the stock. That check does not verify the result required here: compare sales and return totals under common slicers.
B:The title should avoid showing a misleading single region. That check does not verify the result required here: compare sales and return totals under common slicers.
D:Speed improvements cannot change correct business values. That check does not verify the result required here: compare sales and return totals under common slicers.
Question 212
Two fact tables share a Product dimension but should not be directly joined row to row. A specific ongoing problem has appeared: An accidental fact-to-fact many-to-many path may double count. Which safeguard most directly addresses it?
- Retain necessary iterators for true row-level arithmetic.
- Keep a governed detailed source separately if deeper drilldown is required.
- Keep grains and filter paths documented and unambiguous.
- Maintain a continuous marked date table and calendar assumptions.
Explanation
Correct Answer
C:Conformed dimensions enable reliable comparisons.
Incorrect Answers
A:Do not sacrifice correctness for superficial expression simplicity; conformed dimensions enable reliable comparisons.
B:Granularity reduction trades detail for performance. Conformed dimensions enable reliable comparisons.
D:Time intelligence needs reliable date semantics. Conformed dimensions enable reliable comparisons.
Question 213
An analyst needs a row-level tax band stored for each transaction and reused as a slicer. Which Power BI approach most directly satisfies this requirement?
- Set measure format strings rather than converting numerical values to text.
- Activate an alternate relationship inside a specific DAX measure.
- Connect multiple fact tables through conformed dimensions.
- Use a calculated column when a stored row attribute is needed.
Explanation
Correct Answer
D:Calculated columns materialize per-row results in the model, unlike measures evaluated on demand.
Incorrect Answers
A:A formatted numeric measure remains usable in sorting and arithmetic. Calculated columns materialize per-row results in the model, unlike measures evaluated on demand.
B:USERELATIONSHIP can select an inactive relationship within a CALCULATE expression; calculated columns materialize per-row results in the model, unlike measures evaluated on demand.
C:Shared dimensions support consistent slicing of separate fact grains. Calculated columns materialize per-row results in the model, unlike measures evaluated on demand.
Question 214
A reporting model needs a durable per-product category derived at refresh time. The selected approach is: Use a calculated column when a stored row attribute is needed. Which implementation step puts it into practice?
- Disable or refactor conflicting paths and use explicit measure context where needed.
- Create the row expression and assign its data type and category.
- Use CALCULATE with USERELATIONSHIP on the intended date columns.
- Build a unique continuous Date column and mark it as the model date table.
Explanation
Correct Answer
B:The column must be calculated from appropriate row context.
Incorrect Answers
A:Each measure should have an intended unambiguous filter route. It does not implement the needed solution: use a calculated column when a stored row attribute is needed.
C:This changes the date filtering of that measure without making both relationships globally active. It does not implement the needed solution: use a calculated column when a stored row attribute is needed.
D:Time intelligence relies on correct date semantics and relationships. It does not implement the needed solution: use a calculated column when a stored row attribute is needed.
Question 215
An analyst needs a row-level tax band stored for each transaction and reused as a slicer. The chosen solution is: Use a calculated column when a stored row attribute is needed. Which TWO actions together implement this approach and provide evidence that it works? Choose TWO.
- Use CALCULATE with USERELATIONSHIP on the intended date columns.
- Test the derived attribute against sample source rows.
- Compare each calculation item with trusted individual measure results.
- Create the row expression and assign its data type and category.
- Compare model memory and report results after the change.
Explanation
Correct Answers
B:Row-level classification should be reproducible.
D:The column must be calculated from appropriate row context.
Incorrect Answers
A:This changes the date filtering of that measure without making both relationships globally active. It does not implement the needed solution: use a calculated column when a stored row attribute is needed.
C:Reusable logic must produce consistent values and formats. That check does not verify the result required here: test the derived attribute against sample source rows.
E:Storage savings should not remove required relationships or metrics. That check does not verify the result required here: test the derived attribute against sample source rows.
Question 216
An analyst needs a row-level tax band stored for each transaction and reused as a slicer. A specific ongoing problem has appeared: Calculated columns increase model size. Which safeguard most directly addresses it?
- Validate grain and duplicate records before interpreting row-count KPIs.
- Avoid unnecessary high-cardinality calculated columns.
- Maintain a continuous marked date table and calendar assumptions.
- Use last available snapshot rather than assuming every month end has a row.
Explanation
Correct Answer
B:Storing many per-row values consumes memory.
Incorrect Answers
A:COUNTROWS cannot distinguish genuine and duplicate records automatically; storing many per-row values consumes memory.
C:Time intelligence needs reliable date semantics; storing many per-row values consumes memory.
D:Semi-additive measures must handle missing snapshot days. Storing many per-row values consumes memory.
Question 217
A report needs a helper table containing only unique combinations of Store and Region. Which Power BI approach most directly satisfies this requirement?
- Use a calculated table when a materialized model table is justified.
- 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.
Explanation
Correct Answer
A:Calculated tables are computed during processing and then stored.
Incorrect Answers
B:A formatted numeric measure remains usable in sorting and arithmetic; calculated tables are computed during processing and then stored.
C:A business ID alone is not unique when versioned dimension rows exist. Calculated tables are computed during processing and then stored.
D:Multiple active paths can yield unexpected filter propagation; calculated tables are computed during processing and then stored.
Question 218
A modeler wants an auxiliary calculated table to support reporting scenarios at refresh time. The selected approach is: Use a calculated table when a materialized model table is justified. Which implementation step puts it into practice?
- Disable or refactor conflicting paths and use explicit measure context where needed.
- Configure relationship filter direction to follow the star schema.
- Apply currency or percentage format to the correct model measure.
- Define the DAX table expression and establish appropriate relationships.
Explanation
Correct Answer
D:A calculated table needs valid keys and load-time semantics.
Incorrect Answers
A:Each measure should have an intended unambiguous filter route. It does not implement the needed solution: use a calculated table when a materialized model table is justified.
B:An unnecessary bidirectional filter can create ambiguous paths. It does not implement the needed solution: use a calculated table when a materialized model table is justified.
C:Formatting should not alter the measure's numeric data type. It does not implement the needed solution: use a calculated table when a materialized model table is justified.
Question 219
A report needs a helper table containing only unique combinations of Store and Region. The chosen solution is: Use a calculated table when a materialized model table is justified. Which verification best demonstrates that it meets the requirement?
- Test core totals under combined slicers and compare query performance.
- Inspect unique rows and relationship behavior after refresh.
- Compare the measure with known prior-month totals.
- Compare outputs against the pre-refactor measure across filters.
Explanation
Correct Answer
B:Verify the table's intended distinct combinations.
Incorrect Answers
A:Correctness and runtime both matter. That check does not verify the result required here: inspect unique rows and relationship behavior after refresh.
C:It should align period filters with the shifted interval. That check does not verify the result required here: inspect unique rows and relationship behavior after refresh.
D:Refactoring should not change intended results. That check does not verify the result required here: inspect unique rows and relationship behavior after refresh.
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.
Microsoft Power BI Data Analyst (PL-300) Practice Tests