100% Latest & Updated Microsoft PL-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 140
A date field is imported as text and Power BI cannot apply appropriate date operations. A specific ongoing problem has appeared: Automatic type detection may vary when source files change. Which safeguard most directly addresses it?
- Check type errors and column schema in refresh diagnostics.
- Monitor unmatched values and normalization exceptions.
- Review SQL source performance and reduce unnecessary DirectQuery visual requests.
- Monitor credential expiry policies and refresh authentication failures.
Explanation
Correct Answer
A:A bad type change can corrupt downstream calculations.
Incorrect Answers
B:Recurring quality checks reveal new categories rather than silently combining distinct labels. A bad type change can corrupt downstream calculations.
C:DirectQuery depends on source responsiveness; inefficient visuals or queries can stall interactive reports; a bad type change can corrupt downstream calculations.
D:Credential lifecycle controls reduce repeated unattended failures. A bad type change can corrupt downstream calculations.
Question 141
A business needs a risk category derived from a numeric score using clear thresholds. Which Power BI approach most directly satisfies this requirement?
- Duplicate the query to copy its current transformation steps.
- Add a conditional column using explicit ordered conditions.
- Create or select a unique dimension key at the intended grain.
- Group rows by the intended dimensions and aggregate the measure.
Explanation
Correct Answer
B:Conditional columns transform known business rules into derived attributes.
Incorrect Answers
A:Duplicate creates a separate query definition rather than a live dependent reference. Conditional columns transform known business rules into derived attributes.
C:Relationships require stable matching identifiers without duplicate dimension-side keys. Conditional columns transform known business rules into derived attributes.
D:Power Query Group By changes grain to the requested summary level; conditional columns transform known business rules into derived attributes.
Question 142
An operations analyst wants to label late deliveries based on a duration cutoff. The selected approach is: Add a conditional column using explicit ordered conditions. Which implementation step puts it into practice?
- Select grouping keys and sum or average with documented aggregation semantics.
- Define ordered if-then conditions and a default outcome.
- Choose the correct join kind and expand only needed lookup columns.
- Change Type with correct culture and verify conversion errors.
Explanation
Correct Answer
B:Rule ordering and fallback values determine the classifications.
Incorrect Answers
A:Grouping must preserve intended additive measure behavior. It does not implement the needed solution: add a conditional column using explicit ordered conditions.
C:Join choice controls whether unmatched base rows remain or disappear. It does not implement the needed solution: add a conditional column using explicit ordered conditions.
D:A type step should match the source's actual value format. It does not implement the needed solution: add a conditional column using explicit ordered conditions.
Question 143
A business needs a risk category derived from a numeric score using clear thresholds. The chosen solution is: Add a conditional column using explicit ordered conditions. Which TWO actions together implement this approach and provide evidence that it works? Choose TWO.
- Count valid unique keys after handling missing records.
- Test boundary values just below and above the threshold.
- Change Type with correct culture and verify conversion errors.
- Define ordered if-then conditions and a default outcome.
- Compare the report's core measures with the authoritative shared model.
Explanation
Correct Answers
B:Boundary checks detect off-by-one category errors.
D:Rule ordering and fallback values determine the classifications.
Incorrect Answers
A:The cleaned dimension should have an expected usable key population. That check does not verify the result required here: test boundary values just below and above the threshold.
C:A type step should match the source's actual value format. It does not implement the needed solution: add a conditional column using explicit ordered conditions.
E:The thin report should return the governed KPI definitions. That check does not verify the result required here: test boundary values just below and above the threshold.
Question 144
A business needs a risk category derived from a numeric score using clear thresholds. A specific ongoing problem has appeared: Stakeholders may revise scoring thresholds. Which safeguard most directly addresses it?
- Reject unexpected files or changed columns in the folder pipeline.
- Parameterize or document threshold changes and regression test boundary cases.
- Monitor semantic model refresh history and refresh failure alerts.
- Validate date distributions and detect locale-pattern shifts.
Explanation
Correct Answer
B:Rule changes can silently reclassify historical rows.
Incorrect Answers
A:Folder ingestion requires checks for format drift and unwanted files; rule changes can silently reclassify historical rows.
C:Import copies can become stale; monitoring refresh success catches missing updates; rule changes can silently reclassify historical rows.
D:Unexpected date patterns reveal import errors early. Rule changes can silently reclassify historical rows.
Question 145
A fact and lookup dimension have different natural keys and need a stable relationship key. Which Power BI approach most directly satisfies this requirement?
- Create or select a unique dimension key at the intended grain.
- Expand JSON records and lists into the required tabular fields.
- Disable load for the staging query while leaving its dependents enabled.
- Unpivot repeated period columns into attribute-value rows.
Explanation
Correct Answer
A:Relationships require stable matching identifiers without duplicate dimension-side keys.
Incorrect Answers
B:Power Query can transform semi-structured JSON to tables by expanding structures; relationships require stable matching identifiers without duplicate dimension-side keys.
C:An intermediate query need not load duplicate tables to the model. Relationships require stable matching identifiers without duplicate dimension-side keys.
D:Unpivot converts wide period fields into tidy rows for filtering and analysis; relationships require stable matching identifiers without duplicate dimension-side keys.
Question 146
A product dimension contains multiple attributes but facts require one uniquely identifying product key. The selected approach is: Create or select a unique dimension key at the intended grain. Which implementation step puts it into practice?
- Clear Enable Load on the staging query and retain reference dependencies.
- Parse the source period and derive month-start dates with correct locale.
- Use Transpose then promote the appropriate first row to headers.
- Validate uniqueness and missing matches before defining relationships.
Explanation
Correct Answer
D:A nonunique dimension key can cause an unexpected many-to-many relation.
Incorrect Answers
A:Dependent queries can still use the intermediate transformations. It does not implement the needed solution: create or select a unique dimension key at the intended grain.
B:Date normalization avoids comparing inconsistent strings. It does not implement the needed solution: create or select a unique dimension key at the intended grain.
C:The sequence aligns record fields with table columns. It does not implement the needed solution: create or select a unique dimension key at the intended grain.
Question 147
A fact and lookup dimension have different natural keys and need a stable relationship key. The chosen solution is: Create or select a unique dimension key at the intended grain. Which verification best demonstrates that it meets the requirement?
- Run an authenticated refresh after updating credentials.
- Inspect unmatched fact keys and one-to-many relationships.
- Compare report query results with fresh SQL source changes.
- Verify the queries point to the new instance and preserve column semantics.
Explanation
Correct Answer
B:Key integrity should support consistent filtering.
Incorrect Answers
A:A successful refresh confirms the service can access its source. That check does not verify the result required here: inspect unmatched fact keys and one-to-many relationships.
C:New source records should be visible to queries without an Import refresh, subject to source and cache behavior. That check does not verify the result required here: inspect unmatched fact keys and one-to-many relationships.
D:Correct data source switching should leave report logic coherent. That check does not verify the result required here: inspect unmatched fact keys and one-to-many relationships.
Question 148
A fact and lookup dimension have different natural keys and need a stable relationship key. A specific ongoing problem has appeared: A source update introduces previously unseen identifiers. Which safeguard most directly addresses it?
- Validate date distributions and detect locale-pattern shifts.
- Confirm parameter values and credentials before deployment and refresh.
- Document whether statistics refer to the preview or whole dataset.
- Monitor referential integrity and unmatched key rates.
Explanation
Correct Answer
D:New fact keys should be assigned to valid dimension members.
Incorrect Answers
A:Unexpected date patterns reveal import errors early; new fact keys should be assigned to valid dimension members.
B:Environment-aware validation prevents accidental cross-environment connections. New fact keys should be assigned to valid dimension members.
C:The sampling scope must be clear when using profile results; new fact keys should be assigned to valid dimension members.
Question 149
An intermediary query stages data solely for two other Power Query transformations. Which Power BI approach most directly satisfies this requirement?
- Pivot a categorical attribute into separate columns.
- Transpose the table before promoting the intended headers.
- Disable load for the staging query while leaving its dependents enabled.
- Unpivot repeated period columns into attribute-value rows.
Explanation
Correct Answer
C:An intermediate query need not load duplicate tables to the model.
Incorrect Answers
A:Pivot turns distinct attribute values into columns with appropriate aggregation. An intermediate query need not load duplicate tables to the model.
B:Transposition swaps row and column orientation for a consistently rotated layout; an intermediate query need not load duplicate tables to the model.
D:Unpivot converts wide period fields into tidy rows for filtering and analysis; an intermediate query need not load duplicate tables to the model.
Question 150
A raw data cleaning query supports several loaded output queries but should not appear as its own model table. The selected approach is: Disable load for the staging query while leaving its dependents enabled. Which implementation step puts it into practice?
- Apply Fill Down after sorting or preserving the correct original row order.
- Convert list and record nodes to tables then expand selected fields.
- Clear Enable Load on the staging query and retain reference dependencies.
- Use Split Column by Delimiter with correct split-at and type rules.
Explanation
Correct Answer
C:Dependent queries can still use the intermediate transformations.
Incorrect Answers
A:The operation depends on relative row ordering and valid group boundaries. It does not implement the needed solution: disable load for the staging query while leaving its dependents enabled.
B:The analyst should choose fields and preserve parent keys. It does not implement the needed solution: disable load for the staging query while leaving its dependents enabled.
D:The transform should respect codes that may contain multiple delimiters. It does not implement the needed solution: disable load for the staging query while leaving its dependents enabled.
Microsoft Power BI Data Analyst (PL-300) Practice Tests