100% Latest & Updated Microsoft PL-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 190
A service model needs a delivery-date measure while its default Calendar relationship is based on request date. The selected approach is: Activate an alternate relationship inside a specific DAX measure. Which implementation step puts it into practice?
- Use CALCULATE with USERELATIONSHIP on the intended date columns.
- Keep sales line events in a fact table and join dimensions through keys.
- Document a unique row key and use grain-consistent measures.
- Apply currency or percentage format to the correct model measure.
Explanation
Correct Answer
A:This changes the date filtering of that measure without making both relationships globally active.
Incorrect Answers
B:The fact grain and dimension identities should support one-to-many filter relationships. It does not implement the needed solution: activate an alternate relationship inside a specific dax measure.
C:Measures such as order count may require DISTINCTCOUNT of an order identifier. It does not implement the needed solution: activate an alternate relationship inside a specific dax measure.
D:Formatting should not alter the measure's numeric data type. It does not implement the needed solution: activate an alternate relationship inside a specific dax measure.
Question 191
A fact table has one active OrderDate relation and an inactive ShipDate relation to the calendar. The chosen solution is: Activate an alternate relationship inside a specific DAX measure. Which TWO actions together implement this approach and provide evidence that it works? Choose TWO.
- Check the monthly value against the last recorded daily balance.
- Use CALCULATE with USERELATIONSHIP on the intended date columns.
- Compare query results and execution characteristics consistently.
- Compare selected-date totals for the two date-role measures.
- Keep sales line events in a fact table and join dimensions through keys.
Explanation
Correct Answers
B:This changes the date filtering of that measure without making both relationships globally active.
D:The two measures should differ when order and shipment dates differ.
Incorrect Answers
A:A sum across dates would overstate the stock. That check does not verify the result required here: compare selected-date totals for the two date-role measures.
C:Speed improvements cannot change correct business values. That check does not verify the result required here: compare selected-date totals for the two date-role measures.
E:The fact grain and dimension identities should support one-to-many filter relationships. It does not implement the needed solution: activate an alternate relationship inside a specific dax measure.
Question 192
A fact table has one active OrderDate relation and an inactive ShipDate relation to the calendar. A specific ongoing problem has appeared: An author may make both overlapping date paths active. Which safeguard most directly addresses it?
- Validate filter-context assumptions around variables.
- Test folding after substantive query edits.
- Scope filter-removal expressions to the intended dimension.
- Keep relationship roles explicit to prevent ambiguous filtering.
Explanation
Correct Answer
D:Measure-specific activation is safer than an unclear global path.
Incorrect Answers
A:Moving a variable can change evaluation semantics; measure-specific activation is safer than an unclear global path.
B:The physical execution plan can change with transformations. Measure-specific activation is safer than an unclear global path.
C:Broad ALL-table removal can change more context than required; measure-specific activation is safer than an unclear global path.
Question 193
A financial model needs year-to-date reporting based on a continuous reporting calendar. Which Power BI approach most directly satisfies this requirement?
- Prefer single-direction filtering from dimensions to fact where appropriate.
- Hide technical columns and provide clear measure/field properties.
- Create a proper date table and mark it for time intelligence as appropriate.
- Choose a dimension key at the model's intended historical grain.
Explanation
Correct Answer
C:A contiguous calendar with a date column supports reliable time calculations.
Incorrect Answers
A:Simple one-to-many star schemas generally use predictable dimension-to-fact filters. A contiguous calendar with a date column supports reliable time calculations.
B:Metadata design helps authors use intended business fields; a contiguous calendar with a date column supports reliable time calculations.
D:A business ID alone is not unique when versioned dimension rows exist; a contiguous calendar with a date column supports reliable time calculations.
Question 194
A subscription report needs a consistent complete date dimension covering all transaction dates. The selected approach is: Create a proper date table and mark it for time intelligence as appropriate. Which implementation step puts it into practice?
- Build a unique continuous Date column and mark it as the model date table.
- Apply currency or percentage format to the correct model measure.
- Hide surrogate keys and set appropriate categories, names and formatting.
- Disable or refactor conflicting paths and use explicit measure context where needed.
Explanation
Correct Answer
A:Time intelligence relies on correct date semantics and relationships.
Incorrect Answers
B:Formatting should not alter the measure's numeric data type. It does not implement the needed solution: create a proper date table and mark it for time intelligence as appropriate.
C:The fields pane should emphasize business-friendly measures. It does not implement the needed solution: create a proper date table and mark it for time intelligence as appropriate.
D:Each measure should have an intended unambiguous filter route. It does not implement the needed solution: create a proper date table and mark it for time intelligence as appropriate.
Question 195
A financial model needs year-to-date reporting based on a continuous reporting calendar. The chosen solution is: Create a proper date table and mark it for time intelligence as appropriate. Which verification best demonstrates that it meets the requirement?
- Inspect query folding and compare refresh time after the change.
- Change slicers and verify ranks recalculate among the intended stores.
- Test monthly, prior-year and year-to-date measures across missing transaction days.
- Check January reset and December accumulated totals.
Explanation
Correct Answer
C:The calendar should supply dates even when no facts occurred.
Incorrect Answers
A:Folded filters should improve refresh efficiency. That check does not verify the result required here: test monthly, prior-year and year-to-date measures across missing transaction days.
B:Rank 1 should match the highest measure within scope. That check does not verify the result required here: test monthly, prior-year and year-to-date measures across missing transaction days.
D:A YTD measure should reset at the correct boundary. That check does not verify the result required here: test monthly, prior-year and year-to-date measures across missing transaction days.
Question 196
A financial model needs year-to-date reporting based on a continuous reporting calendar. A specific ongoing problem has appeared: A calendar that omits dates may break comparisons. Which safeguard most directly addresses it?
- Document how unavailable ratios are displayed.
- Test format strings and precedence across report visuals.
- Refresh and validate the date table range for the reporting horizon.
- Specify the correct fiscal year end in time calculations.
Explanation
Correct Answer
C:Coverage must include all required periods.
Incorrect Answers
A:Blank and zero carry different business meanings; coverage must include all required periods.
B:Calculation items can affect evaluation and presentation order. Coverage must include all required periods.
D:Wrong year-end definitions misstate YTD figures. Coverage must include all required periods.
Question 197
A published model shows surrogate keys and technical helper columns in the Fields pane for report authors. Which Power BI approach most directly satisfies this requirement?
- Define fact-table grain before building measures and relationships.
- Create a proper date table and mark it for time intelligence as appropriate.
- Hide technical columns and provide clear measure/field properties.
- Connect multiple fact tables through conformed dimensions.
Explanation
Correct Answer
C:Metadata design helps authors use intended business fields.
Incorrect Answers
A:Knowing whether one row means a line, package, or order prevents incorrect aggregation. Metadata design helps authors use intended business fields.
B:A contiguous calendar with a date column supports reliable time calculations; metadata design helps authors use intended business fields.
D:Shared dimensions support consistent slicing of separate fact grains; metadata design helps authors use intended business fields.
Question 198
A finance semantic model needs user-facing labels without exposing internal join identifiers. The selected approach is: Hide technical columns and provide clear measure/field properties. Which implementation step puts it into practice?
- Hide surrogate keys and set appropriate categories, names and formatting.
- Use CALCULATE with USERELATIONSHIP on the intended date columns.
- Configure relationship filter direction to follow the star schema.
- Create the row expression and assign its data type and category.
Explanation
Correct Answer
A:The fields pane should emphasize business-friendly measures.
Incorrect Answers
B:This changes the date filtering of that measure without making both relationships globally active. It does not implement the needed solution: hide technical columns and provide clear measure/field properties.
C:An unnecessary bidirectional filter can create ambiguous paths. It does not implement the needed solution: hide technical columns and provide clear measure/field properties.
D:The column must be calculated from appropriate row context. It does not implement the needed solution: hide technical columns and provide clear measure/field properties.
Question 199
A published model shows surrogate keys and technical helper columns in the Fields pane for report authors. The chosen solution is: Hide technical columns and provide clear measure/field properties. Which verification best demonstrates that it meets the requirement?
- Compare aggregated totals and interactive performance with the detailed baseline.
- Check expected row counts with filters and null IDs.
- Ask report authors to locate core KPIs without seeing irrelevant identifiers.
- Compare model memory and report results after the change.
Explanation
Correct Answer
C:Usability improves when the model exposes fewer technical details.
Incorrect Answers
A:Summaries must preserve report metrics. That check does not verify the result required here: ask report authors to locate core kpis without seeing irrelevant identifiers.
B:The result should not silently skip rows with blank optional fields. That check does not verify the result required here: ask report authors to locate core kpis without seeing irrelevant identifiers.
D:Storage savings should not remove required relationships or metrics. That check does not verify the result required here: ask report authors to locate core kpis without seeing irrelevant identifiers.
Question 200
A published model shows surrogate keys and technical helper columns in the Fields pane for report authors. A specific ongoing problem has appeared: A renamed key might accidentally break an existing relationship. Which safeguard most directly addresses it?
- Optimize row grain and avoid repeated costly iterator work.
- Validate underlying relationships after model metadata changes.
- Retain necessary iterators for true row-level arithmetic.
- Document whether the rank ignores or preserves user selections.
Explanation
Correct Answer
B:Hidden fields may still be required technically.
Incorrect Answers
A:Iterators may be more expensive than simple storage-engine aggregations; hidden fields may still be required technically.
C:Do not sacrifice correctness for superficial expression simplicity; hidden fields may still be required technically.
D:Ranking semantics depend on the chosen table context. Hidden fields may still be required technically.
Microsoft Power BI Data Analyst (PL-300) Practice Tests