100% Latest & Updated Microsoft PL-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 260
A card needs total company revenue regardless of which product is selected, but must preserve date filters. A specific ongoing problem has appeared: Removing all filters could ignore required time or security context. Which safeguard most directly addresses it?
- Scope filter-removal expressions to the intended dimension.
- Validate uniqueness at the chosen effective-dated key.
- Refresh and validate the date table range for the reporting horizon.
- Keep a governed detailed source separately if deeper drilldown is required.
Explanation
Correct Answer
A:Broad ALL-table removal can change more context than required.
Incorrect Answers
B:Versioned dimensions require consistent key strategy. Broad ALL-table removal can change more context than required.
C:Coverage must include all required periods; broad ALL-table removal can change more context than required.
D:Granularity reduction trades detail for performance. Broad ALL-table removal can change more context than required.
Question 261
A report title should show the selected Region when exactly one region is filtered. Which Power BI approach most directly satisfies this requirement?
- Use a SUM measure for an additive numeric column.
- Use SELECTEDVALUE with a reasonable alternate text.
- Use KEEPFILTERS to intersect filters on the same column.
- Use SAMEPERIODLASTYEAR for a matching previous-year period.
Explanation
Correct Answer
B:SELECTEDVALUE returns a scalar when one distinct value is visible.
Incorrect Answers
A:A measure aggregates within current filter context rather than storing a fixed total. SELECTEDVALUE returns a scalar when one distinct value is visible.
C:KEEPFILTERS changes CALCULATE filter handling to preserve intersections. SELECTEDVALUE returns a scalar when one distinct value is visible.
D:The function shifts the selected date context by one year under suitable calendar semantics; SELECTEDVALUE returns a scalar when one distinct value is visible.
Question 262
A measure needs the chosen currency code only when one currency value is selected. The selected approach is: Use SELECTEDVALUE with a reasonable alternate text. Which implementation step puts it into practice?
- Define SELECTEDVALUE(Region[Name], "Multiple regions").
- Use CALCULATE([Revenue], REMOVEFILTERS(Product)) for the denominator.
- Create a calculated column = RELATED(Product[Category]) with the relationship present.
- Select the last available reporting date and evaluate the balance at that date.
Explanation
Correct Answer
A:An alternate handles zero or many selections.
Incorrect Answers
B:The Product selection is ignored for the total while other filters remain. It does not implement the needed solution: use selectedvalue with a reasonable alternate text.
C:Row context plus relationship allows lookup of dimension values. It does not implement the needed solution: use selectedvalue with a reasonable alternate text.
D:The measure should use the relevant final snapshot for a period. It does not implement the needed solution: use selectedvalue with a reasonable alternate text.
Question 263
A report title should show the selected Region when exactly one region is filtered. The chosen solution is: Use SELECTEDVALUE with a reasonable alternate text. Which TWO actions together implement this approach and provide evidence that it works? Choose TWO.
- Measure model size and refresh duration after pruning.
- Assign meaningful variables before the RETURN expression.
- Test zero, one and multiple selected values in slicers.
- Verify each fact row maps to the expected calendar day.
- Define SELECTEDVALUE(Region[Name], "Multiple regions").
Explanation
Correct Answers
C:The title should avoid showing a misleading single region.
E:An alternate handles zero or many selections.
Incorrect Answers
A:Smaller data should not change required report values. That check does not verify the result required here: test zero, one and multiple selected values in slicers.
B:The final result can reuse scalar or table values consistently. It does not implement the needed solution: use selectedvalue with a reasonable alternate text.
D:Date joins must preserve correct day boundaries. That check does not verify the result required here: test zero, one and multiple selected values in slicers.
Question 264
A report title should show the selected Region when exactly one region is filtered. A specific ongoing problem has appeared: Multi-select behavior might surprise users. Which safeguard most directly addresses it?
- Review relationship diagrams whenever the model changes.
- Validate dimension-side key uniqueness and relationship cardinality.
- Retain numeric results with model-level formatting where possible.
- Define a clear fallback for ambiguous selections.
Explanation
Correct Answer
D:An explicit alternate prevents blank or confusing labels.
Incorrect Answers
A:Model structure is central to DAX correctness; an explicit alternate prevents blank or confusing labels.
B:Duplicate lookup keys undermine expected one-to-many semantics. An explicit alternate prevents blank or confusing labels.
C:Format strings control presentation without changing value type; an explicit alternate prevents blank or confusing labels.
Question 265
A calculated column on Sales needs to look up Category from a related Product dimension. Which Power BI approach most directly satisfies this requirement?
- Use RANKX with an explicitly defined ranking table.
- Use RELATED in row context with a valid relationship.
- Use a semi-additive last-observation measure over dates.
- Use SUMX for a row-wise expression before aggregating.
Explanation
Correct Answer
B:RELATED retrieves a related one-side attribute for a row expression.
Incorrect Answers
A:RANKX evaluates expressions across a table to establish relative ranks. RELATED retrieves a related one-side attribute for a row expression.
C:Snapshot values may aggregate across entities but not across time. RELATED retrieves a related one-side attribute for a row expression.
D:SUMX iterates visible rows and sums an expression evaluated for each row; RELATED retrieves a related one-side attribute for a row expression.
Question 266
A fact row needs a descriptive attribute from the one-side Customer table. The selected approach is: Use RELATED in row context with a valid relationship. Which implementation step puts it into practice?
- Select the last available reporting date and evaluate the balance at that date.
- Define RANKX(ALLSELECTED(Store[Store]), [Revenue]) for the intended ranking scope.
- Define CALCULATE([Sales], SAMEPERIODLASTYEAR('Date'[Date])).
- Create a calculated column = RELATED(Product[Category]) with the relationship present.
Explanation
Correct Answer
D:Row context plus relationship allows lookup of dimension values.
Incorrect Answers
A:The measure should use the relevant final snapshot for a period. It does not implement the needed solution: use related in row context with a valid relationship.
B:The ranking universe must match user-selected context. It does not implement the needed solution: use related in row context with a valid relationship.
C:The comparison measure uses shifted dates to evaluate the base measure. It does not implement the needed solution: use related in row context with a valid relationship.
Question 267
A calculated column on Sales needs to look up Category from a related Product dimension. The chosen solution is: Use RELATED in row context with a valid relationship. Which verification best demonstrates that it meets the requirement?
- Compare model memory and report results after the change.
- Check retrieved categories against sample keys.
- Validate visual labels and aggregations remain numeric.
- Compare aggregated totals and interactive performance with the detailed baseline.
Explanation
Correct Answer
B:Mismatched or missing relation keys cause missing values.
Incorrect Answers
A:Storage savings should not remove required relationships or metrics. That check does not verify the result required here: check retrieved categories against sample keys.
C:The displayed number and the measure's arithmetic must both remain correct. That check does not verify the result required here: check retrieved categories against sample keys.
D:Summaries must preserve report metrics. That check does not verify the result required here: check retrieved categories against sample keys.
Question 268
A calculated column on Sales needs to look up Category from a related Product dimension. A specific ongoing problem has appeared: Changing relationships can alter calculated column results after refresh. Which safeguard most directly addresses it?
- Use measures for dynamic filter-context results instead of stored tables.
- Revalidate key matches and refresh calculated columns after model changes.
- Review filter paths before enabling bidirectional relationships.
- Retain necessary iterators for true row-level arithmetic.
Explanation
Correct Answer
B:The expression depends on relationship integrity.
Incorrect Answers
A:Choose an object type that matches the required evaluation time; the expression depends on relationship integrity.
C:Both directions can introduce unexpected ambiguity and performance costs; the expression depends on relationship integrity.
D:Do not sacrifice correctness for superficial expression simplicity. The expression depends on relationship integrity.
Question 269
A fact table stores Quantity and UnitPrice but not a precomputed line amount. Which Power BI approach most directly satisfies this requirement?
- Use SUMX for a row-wise expression before aggregating.
- Use VAR and RETURN to name reusable intermediate values.
- Use COUNTROWS to count table records.
- Use KEEPFILTERS to intersect filters on the same column.
Explanation
Correct Answer
A:SUMX iterates visible rows and sums an expression evaluated for each row.
Incorrect Answers
B:Variables make measures easier to read and can avoid repeated computation; SUMX iterates visible rows and sums an expression evaluated for each row.
C:COUNTROWS counts rows in the visible table regardless of a particular column's blank values. SUMX iterates visible rows and sums an expression evaluated for each row.
D:KEEPFILTERS changes CALCULATE filter handling to preserve intersections; SUMX iterates visible rows and sums an expression evaluated for each row.
Question 270
A sales model needs revenue from multiplying each line's quantity by price. The selected approach is: Use SUMX for a row-wise expression before aggregating. Which implementation step puts it into practice?
- Define SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]).
- Wrap the CALCULATE filter argument with KEEPFILTERS.
- Use CALCULATE([Revenue], REMOVEFILTERS(Product)) for the denominator.
- Create a calculated column = RELATED(Product[Category]) with the relationship present.
Explanation
Correct Answer
A:Per-row multiplication occurs before aggregation; multiplying column sums would differ.
Incorrect Answers
B:The measure should narrow rather than overwrite an existing selection. It does not implement the needed solution: use sumx for a row-wise expression before aggregating.
C:The Product selection is ignored for the total while other filters remain. It does not implement the needed solution: use sumx for a row-wise expression before aggregating.
D:Row context plus relationship allows lookup of dimension values. It does not implement the needed solution: use sumx for a row-wise expression before aggregating.
Microsoft Power BI Data Analyst (PL-300) Practice Tests