Microsoft PL-300 Practice Test 30
Question 290
An analyst wants a calculated column to label each Sale as HighValue when its amount exceeds a threshold. A colleague proposes: Use a measure as the model's required stored relationship key. Which explanation BEST identifies the defect in that proposal?
- Many-to-many may conceal a data-quality problem and create ambiguous totals
- Measures change with filter context and cannot act as materialized row relationship keys
- The suggested approach is safe merely because its product name is familiar.
- Calculated columns are materialized at processing time and provide a persisted per-row label
Explanation
Correct Answer
B:Measures change with filter context and cannot act as materialized row relationship keys. This directly explains why the proposal 'Use a measure as the model's required stored relationship key' should not be used.
Incorrect Answers
A:This addresses a different case: A company's sales model has a product table with repeated ProductIDs and cannot establish a one-to-many relationship. It is not the specific defect in 'Use a measure as the model's required stored relationship key'.
C:Product familiarity is not evidence of suitability. The actual defect in this proposal is: Measures change with filter context and cannot act as materialized row relationship keys.
D:This is reasoning supporting the preferred solution 'Use a row-context calculated column for the category when refresh-time classification is acceptable', but it does not directly name the defect in the proposed shortcut.
Question 291
An analyst wants a calculated column to label each Sale as HighValue when its amount exceeds a threshold. After implementing Use a row-context calculated column for the category when refresh-time classification is acceptable, which observation BEST demonstrates that the intended result is actually working?
- The team schedules a future check of whether The category is available for slicers and follows the declared refresh-time rule, but has not observed a result.
- The category is available for slicers and follows the declared refresh-time rule
- The report owner approves Use a row-context calculated column for the category when refresh-time classification is acceptable without testing the resulting behavior.
- ProductIDs become unique and an ordinary one-to-many relationship validates
Explanation
Correct Answer
B:The observation 'The category is available for slicers and follows the declared refresh-time rule' directly tests the intended result. Calculated columns are materialized at processing time and provide a persisted per-row label.
Incorrect Answers
A:A future test is not yet observed operational evidence. The verification must establish: The category is available for slicers and follows the declared refresh-time rule.
C:Approval of a proposed design is not evidence of working behavior. The required observation is: The category is available for slicers and follows the declared refresh-time rule.
D:This belongs to a different case: A company's sales model has a product table with repeated ProductIDs and cannot establish a one-to-many relationship. It does not validate the current change. In the current question, this comparison is made against: An analyst wants a calculated column to label each Sale as HighValue when its amount exceeds a threshold. After implementing Use a row-context calculated column for the category when refresh-time classification is acceptable, which observation BEST demonstrates that the intended result is actually working?
Question 292
The original scenario was: An analyst wants a calculated column to label each Sale as HighValue when its amount exceeds a threshold. The initial solution is already in place. Now this new requirement arises: The threshold must change interactively with a what-if parameter. Which ADDITIONAL action BEST meets the changed condition?
- Use a row-context calculated column for the category when refresh-time classification is acceptable
- Use a measure as the model's required stored relationship key
- The category is available for slicers and follows the declared refresh-time rule
- Switch to a measure-driven classification or conditional display logic
Explanation
Correct Answer
D:The changed requirement is 'The threshold must change interactively with a what-if parameter'. The additional response is 'Switch to a measure-driven classification or conditional display logic'.
Incorrect Answers
A:This is the already implemented original solution: Use a row-context calculated column for the category when refresh-time classification is acceptable. Calculated columns are materialized at processing time and provide a persisted per-row label. It does not itself solve the new requirement.
B:This remains unsuitable for the original situation: Measures change with filter context and cannot act as materialized row relationship keys. It also does not meet the changed need.
C:This observes the original approach but is not an additional action: The category is available for slicers and follows the declared refresh-time rule.
Question 293
A model needs a calendar that spans minimum and maximum transaction dates. Which approach BEST meets the stated Microsoft Power BI requirement?
- Create a Date table with CALENDAR or a supported calendar-generation approach
- Generate dates from governed planning start and end boundaries
- Prefer single-direction dimension-to-fact filtering unless a specific need is validated
- Use transaction dates directly even though several transactions occur each day
Explanation
Correct Answer
A:A dedicated date dimension supplies consistent unique daily rows. For the stated case, Create a Date table with CALENDAR or a supported calendar-generation approach.
Incorrect Answers
B:This might be appropriate after a different requirement arises: A business requires years beyond the observed transaction range. It is not the best initial response to the stated case.
C:This addresses a separate source situation: A report has ambiguous filter paths because both Product and Customer cross-filter the Sales fact bidirectionally. It does not directly satisfy this case's priority.
D:A fact date column can repeat and cannot provide unique daily dimensional rows. The proposed shortcut 'Use transaction dates directly even though several transactions occur each day' fails the documented need.
Question 294
A model needs a calendar that spans minimum and maximum transaction dates. A colleague proposes: Use transaction dates directly even though several transactions occur each day. Which explanation BEST identifies the defect in that proposal?
- The suggested approach is safe merely because its product name is familiar.
- Unnecessary bidirectional filtering can create ambiguous paths
- A dedicated date dimension supplies consistent unique daily rows
- A fact date column can repeat and cannot provide unique daily dimensional rows
Explanation
Correct Answer
D:A fact date column can repeat and cannot provide unique daily dimensional rows. This directly explains why the proposal 'Use transaction dates directly even though several transactions occur each day' should not be used.
Incorrect Answers
A:Product familiarity is not evidence of suitability. The actual defect in this proposal is: A fact date column can repeat and cannot provide unique daily dimensional rows.
B:This addresses a different case: A report has ambiguous filter paths because both Product and Customer cross-filter the Sales fact bidirectionally. It is not the specific defect in 'Use transaction dates directly even though several transactions occur each day'.
C:This is reasoning supporting the preferred solution 'Create a Date table with CALENDAR or a supported calendar-generation approach', but it does not directly name the defect in the proposed shortcut.
Question 295
A model needs a calendar that spans minimum and maximum transaction dates. After implementing Create a Date table with CALENDAR or a supported calendar-generation approach, which observation BEST demonstrates that the intended result is actually working?
- The team schedules a future check of whether The generated Calendar covers the intended range without duplicates or gaps, but has not observed a result.
- The generated Calendar covers the intended range without duplicates or gaps
- Filtering Product affects Sales without unintentionally changing unrelated dimension tables
- The report owner approves Create a Date table with CALENDAR or a supported calendar-generation approach without testing the resulting behavior.
Explanation
Correct Answer
B:The observation 'The generated Calendar covers the intended range without duplicates or gaps' directly tests the intended result. A dedicated date dimension supplies consistent unique daily rows.
Incorrect Answers
A:A future test is not yet observed operational evidence. The verification must establish: The generated Calendar covers the intended range without duplicates or gaps.
C:This belongs to a different case: A report has ambiguous filter paths because both Product and Customer cross-filter the Sales fact bidirectionally. It does not validate the current change.
D:Approval of a proposed design is not evidence of working behavior. The required observation is: The generated Calendar covers the intended range without duplicates or gaps.
Question 296
The original scenario was: A model needs a calendar that spans minimum and maximum transaction dates. The initial solution is already in place. Now this new requirement arises: A business requires years beyond the observed transaction range. Which ADDITIONAL action BEST meets the changed condition?
- Create a Date table with CALENDAR or a supported calendar-generation approach
- Generate dates from governed planning start and end boundaries
- The generated Calendar covers the intended range without duplicates or gaps
- Use transaction dates directly even though several transactions occur each day
Explanation
Correct Answer
B:The changed requirement is 'A business requires years beyond the observed transaction range'. The additional response is 'Generate dates from governed planning start and end boundaries'.
Incorrect Answers
A:This is the already implemented original solution: Create a Date table with CALENDAR or a supported calendar-generation approach. A dedicated date dimension supplies consistent unique daily rows. It does not itself solve the new requirement.
C:This observes the original approach but is not an additional action: The generated Calendar covers the intended range without duplicates or gaps.
D:This remains unsuitable for the original situation: A fact date column can repeat and cannot provide unique daily dimensional rows. It also does not meet the changed need.
Question 297
A multinational retailer has order amounts in different currencies and wants both native and converted revenue. The original need and a later change are both under review: Management adds a scenario switch for budget versus actual exchange rates. Which THREE entries together specify the initial action, direct evidence it works, and an additional action for the changed need? (Select THREE.)
- Model a rate-scenario dimension and controlled measure switching
- Retain the source currency and define conversion logic with correct date/rate grain
- Converted totals reconcile to sampled transaction-date exchange rates
- Consider a flattened Product dimension for a star-schema model
- Build a chain of unnecessary bidirectional relationships between tiny lookup tables
- Convert every currency value by one hardcoded exchange rate regardless of date
Explanation
Correct Answers
A:Correct additional action for the explicitly stated later requirement. When Management adds a scenario switch for budget versus actual exchange rates, use this response: Model a rate-scenario dimension and controlled measure switching.
B:Currency conversion needs an appropriate rate and currency relationship to prevent misaggregation. For the stated case, Retain the source currency and define conversion logic with correct date/rate grain.
C:Correct direct operational evidence. Converted totals reconcile to sampled transaction-date exchange rates. This is a check of the original requirement, not an unperformed plan.
Incorrect Answers
D:This addresses a separate source situation: A purchasing model needs ProductCategory and Brand from a normalized Products reference, but analysts want simpler report filtering. It does not directly satisfy this case's priority. In the current question, this comparison is made against: A multinational retailer has order amounts in different currencies and wants both native and converted revenue. The original need and a later change are both under review: Management adds a scenario switch for budget versus actual exchange rates. Which THREE entries together specify the initial action, direct evidence it works, and an additional action for the changed need? (Select THREE.)
E:This is an unsuitable alternative for a different situation: A purchasing model needs ProductCategory and Brand from a normalized Products reference, but analysts want simpler report filtering. It does not establish the requested action, evidence, or follow-up.
F:Static exchange rates do not reflect approved rate dates and currency pairings. The proposed shortcut 'Convert every currency value by one hardcoded exchange rate regardless of date' fails the documented need.
Question 298
A multinational retailer has order amounts in different currencies and wants both native and converted revenue. A colleague proposes: Convert every currency value by one hardcoded exchange rate regardless of date. Which explanation BEST identifies the defect in that proposal?
- Complex snowflake paths can make filter propagation harder to reason about
- Currency conversion needs an appropriate rate and currency relationship to prevent misaggregation
- Static exchange rates do not reflect approved rate dates and currency pairings
- The suggested approach is safe merely because its product name is familiar.
Explanation
Correct Answer
C:Static exchange rates do not reflect approved rate dates and currency pairings. This directly explains why the proposal 'Convert every currency value by one hardcoded exchange rate regardless of date' should not be used.
Incorrect Answers
A:This addresses a different case: A purchasing model needs ProductCategory and Brand from a normalized Products reference, but analysts want simpler report filtering. It is not the specific defect in 'Convert every currency value by one hardcoded exchange rate regardless of date'.
B:This is reasoning supporting the preferred solution 'Retain the source currency and define conversion logic with correct date/rate grain', but it does not directly name the defect in the proposed shortcut.
D:Product familiarity is not evidence of suitability. The actual defect in this proposal is: Static exchange rates do not reflect approved rate dates and currency pairings.
Question 299
A multinational retailer has order amounts in different currencies and wants both native and converted revenue. After implementing Retain the source currency and define conversion logic with correct date/rate grain, which observation BEST demonstrates that the intended result is actually working?
- Product filters reach the sales fact through one clear dimension path
- The team schedules a future check of whether Converted totals reconcile to sampled transaction-date exchange rates, but has not observed a result.
- The report owner approves Retain the source currency and define conversion logic with correct date/rate grain without testing the resulting behavior.
- Converted totals reconcile to sampled transaction-date exchange rates
Explanation
Correct Answer
D:The observation 'Converted totals reconcile to sampled transaction-date exchange rates' directly tests the intended result. Currency conversion needs an appropriate rate and currency relationship to prevent misaggregation.
Incorrect Answers
A:This belongs to a different case: A purchasing model needs ProductCategory and Brand from a normalized Products reference, but analysts want simpler report filtering. It does not validate the current change. In the current question, this comparison is made against: A multinational retailer has order amounts in different currencies and wants both native and converted revenue. After implementing Retain the source currency and define conversion logic with correct date/rate grain, which observation BEST demonstrates that the intended result is actually working?
B:A future test is not yet observed operational evidence. The verification must establish: Converted totals reconcile to sampled transaction-date exchange rates.
C:Approval of a proposed design is not evidence of working behavior. The required observation is: Converted totals reconcile to sampled transaction-date exchange rates.
Question 300
The original scenario was: A multinational retailer has order amounts in different currencies and wants both native and converted revenue. The initial solution is already in place. Now this new requirement arises: Management adds a scenario switch for budget versus actual exchange rates. Which ADDITIONAL action BEST meets the changed condition?
- Converted totals reconcile to sampled transaction-date exchange rates
- Convert every currency value by one hardcoded exchange rate regardless of date
- Retain the source currency and define conversion logic with correct date/rate grain
- Model a rate-scenario dimension and controlled measure switching
Explanation
Correct Answer
D:The changed requirement is 'Management adds a scenario switch for budget versus actual exchange rates'. The additional response is 'Model a rate-scenario dimension and controlled measure switching'.
Incorrect Answers
A:This observes the original approach but is not an additional action: Converted totals reconcile to sampled transaction-date exchange rates.
B:This remains unsuitable for the original situation: Static exchange rates do not reflect approved rate dates and currency pairings. It also does not meet the changed need.
C:This is the already implemented original solution: Retain the source currency and define conversion logic with correct date/rate grain. Currency conversion needs an appropriate rate and currency relationship to prevent misaggregation. It does not itself solve the new requirement.