100% Latest & Updated Microsoft PL-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 100
A sales worksheet has one product per row but months spread across twelve separate columns. A specific ongoing problem has appeared: A new period column may arrive in later files. Which safeguard most directly addresses it?
- Monitor unmatched values and normalization exceptions.
- Track the rate of conversion errors in refresh diagnostics.
- Document whether statistics refer to the preview or whole dataset.
- Use a resilient unpivot-other-columns pattern with explicit key columns.
Explanation
Correct Answer
D:New period columns should be included without accidentally unpivoting identifiers.
Incorrect Answers
A:Recurring quality checks reveal new categories rather than silently combining distinct labels; new period columns should be included without accidentally unpivoting identifiers.
B:A rising error rate indicates a new source-quality problem. New period columns should be included without accidentally unpivoting identifiers.
C:The sampling scope must be clear when using profile results; new period columns should be included without accidentally unpivoting identifiers.
Question 101
A call center export lists one row per metric but management needs metrics as separate columns. Which Power BI approach most directly satisfies this requirement?
- Group rows by the intended dimensions and aggregate the measure.
- Pivot a categorical attribute into separate columns.
- Disable load for the staging query while leaving its dependents enabled.
- Reference the base query to reuse its transformations.
Explanation
Correct Answer
B:Pivot turns distinct attribute values into columns with appropriate aggregation.
Incorrect Answers
A:Power Query Group By changes grain to the requested summary level. Pivot turns distinct attribute values into columns with appropriate aggregation.
C:An intermediate query need not load duplicate tables to the model. Pivot turns distinct attribute values into columns with appropriate aggregation.
D:A reference creates a dependent query that follows changes in the original; pivot turns distinct attribute values into columns with appropriate aggregation.
Question 102
An audit matrix stores metric labels vertically and needs a wide summary table. The selected approach is: Pivot a categorical attribute into separate columns. Which implementation step puts it into practice?
- Apply foldable filters and inspect the native query where available.
- Create Reference queries and add downstream transformations only where needed.
- Choose the metric-name column and aggregation when pivoting measure values.
- Validate uniqueness and missing matches before defining relationships.
Explanation
Correct Answer
C:Duplicate entity-metric combinations require a deliberate aggregation rule.
Incorrect Answers
A:Native query diagnostics reveal whether a step delegates work to the source. It does not implement the needed solution: pivot a categorical attribute into separate columns.
B:Common cleaning logic remains centralized. It does not implement the needed solution: pivot a categorical attribute into separate columns.
D:A nonunique dimension key can cause an unexpected many-to-many relation. It does not implement the needed solution: pivot a categorical attribute into separate columns.
Question 103
A call center export lists one row per metric but management needs metrics as separate columns. The chosen solution is: Pivot a categorical attribute into separate columns. Which verification best demonstrates that it meets the requirement?
- Verify the resolved server and database in each deployment.
- Inspect the distribution and null percentages for the relevant column.
- Compare converted dates with authoritative source examples.
- Validate pivot totals and uniqueness by the retained row key.
Explanation
Correct Answer
D:Wide columns should preserve intended measures without silent duplication.
Incorrect Answers
A:A correct parameter substitution should target the intended data source without changing transformations. That check does not verify the result required here: validate pivot totals and uniqueness by the retained row key.
B:These statistics drive cleaning rather than arbitrary replacement. That check does not verify the result required here: validate pivot totals and uniqueness by the retained row key.
C:Known ambiguous examples prove whether conversion is correct. That check does not verify the result required here: validate pivot totals and uniqueness by the retained row key.
Question 104
A call center export lists one row per metric but management needs metrics as separate columns. A specific ongoing problem has appeared: New metric categories can change the column schema. Which safeguard most directly addresses it?
- Check schema compatibility before refreshing the switched model.
- Document whether statistics refer to the preview or whole dataset.
- Track shared semantic model changes and test dependent report measures.
- Review new pivot category values at refresh.
Explanation
Correct Answer
D:Unexpected attributes can create missing or extra output columns.
Incorrect Answers
A:Renamed or missing columns can break downstream transformations; unexpected attributes can create missing or extra output columns.
B:The sampling scope must be clear when using profile results. Unexpected attributes can create missing or extra output columns.
C:Thin reports inherit upstream semantics and should be regression tested; unexpected attributes can create missing or extra output columns.
Question 105
A sales fact table needs supplier names from a keyed suppliers lookup table. Which Power BI approach most directly satisfies this requirement?
- Expand JSON records and lists into the required tabular fields.
- Merge Power Query queries by the matching lookup keys.
- Add a conditional column using explicit ordered conditions.
- Transpose the table before promoting the intended headers.
Explanation
Correct Answer
B:Merge performs a horizontal join between related tables.
Incorrect Answers
A:Power Query can transform semi-structured JSON to tables by expanding structures. Merge performs a horizontal join between related tables.
C:Conditional columns transform known business rules into derived attributes. Merge performs a horizontal join between related tables.
D:Transposition swaps row and column orientation for a consistently rotated layout; merge performs a horizontal join between related tables.
Question 106
A service-ticket table must attach regional owner attributes by a stable key. The selected approach is: Merge Power Query queries by the matching lookup keys. Which implementation step puts it into practice?
- Clear Enable Load on the staging query and retain reference dependencies.
- Choose the correct join kind and expand only needed lookup columns.
- Use Transpose then promote the appropriate first row to headers.
- Use Duplicate rather than Reference before changing the experimental steps.
Explanation
Correct Answer
B:Join choice controls whether unmatched base rows remain or disappear.
Incorrect Answers
A:Dependent queries can still use the intermediate transformations. It does not implement the needed solution: merge power query queries by the matching lookup keys.
C:The sequence aligns record fields with table columns. It does not implement the needed solution: merge power query queries by the matching lookup keys.
D:The new query can diverge without tracking later changes to the original steps. It does not implement the needed solution: merge power query queries by the matching lookup keys.
Question 107
A sales fact table needs supplier names from a keyed suppliers lookup table. The chosen solution is: Merge Power Query queries by the matching lookup keys. Which TWO actions together implement this approach and provide evidence that it works? Choose TWO.
- Test a service-side refresh using the configured gateway.
- Validate that sensitive values are not sent to the public source during evaluation.
- Choose the metric-name column and aggregation when pivoting measure values.
- Count matched and unmatched keys and compare output row totals.
- Choose the correct join kind and expand only needed lookup columns.
Explanation
Correct Answers
D:Unexpected duplication indicates nonunique join keys or wrong join direction.
E:Join choice controls whether unmatched base rows remain or disappear.
Incorrect Answers
A:A successful cloud refresh establishes that the service can reach and authenticate to the local source. That check does not verify the result required here: count matched and unmatched keys and compare output row totals.
B:The goal is controlled data combination, not simply successful row matching. That check does not verify the result required here: count matched and unmatched keys and compare output row totals.
C:Duplicate entity-metric combinations require a deliberate aggregation rule. It does not implement the needed solution: merge power query queries by the matching lookup keys.
Question 108
A sales fact table needs supplier names from a keyed suppliers lookup table. A specific ongoing problem has appeared: New lookup duplicates could multiply fact rows. Which safeguard most directly addresses it?
- Monitor semantic model refresh history and refresh failure alerts.
- Review Changed Type steps after schema updates.
- Monitor unmatched values and normalization exceptions.
- Validate lookup-key uniqueness before each merge.
Explanation
Correct Answer
D:Many matching lookup records can inflate the base fact table.
Incorrect Answers
A:Import copies can become stale; monitoring refresh success catches missing updates; many matching lookup records can inflate the base fact table.
B:Automatic type inference can silently alter key fields. Many matching lookup records can inflate the base fact table.
C:Recurring quality checks reveal new categories rather than silently combining distinct labels; many matching lookup records can inflate the base fact table.
Question 109
Four stores produce monthly files with identical sales columns that should become one table. Which Power BI approach most directly satisfies this requirement?
- Reference the base query to reuse its transformations.
- Assign the correct Power Query data types before model loading.
- Append tables with compatible schemas.
- Create or select a unique dimension key at the intended grain.
Explanation
Correct Answer
C:Append adds rows vertically rather than joining columns by key.
Incorrect Answers
A:A reference creates a dependent query that follows changes in the original. Append adds rows vertically rather than joining columns by key.
B:Dates and numerical measures require typed columns for correct analytics; append adds rows vertically rather than joining columns by key.
D:Relationships require stable matching identifiers without duplicate dimension-side keys; append adds rows vertically rather than joining columns by key.
Question 110
Regional service teams export matching ticket tables that need to be stacked into one history. The selected approach is: Append tables with compatible schemas. Which implementation step puts it into practice?
- Apply Fill Down after sorting or preserving the correct original row order.
- Parse the source period and derive month-start dates with correct locale.
- Use Transpose then promote the appropriate first row to headers.
- Align names and types before appending the regional query outputs.
Explanation
Correct Answer
D:The schemas must correspond to avoid unexpected null columns.
Incorrect Answers
A:The operation depends on relative row ordering and valid group boundaries. It does not implement the needed solution: append tables with compatible schemas.
B:Date normalization avoids comparing inconsistent strings. It does not implement the needed solution: append tables with compatible schemas.
C:The sequence aligns record fields with table columns. It does not implement the needed solution: append tables with compatible schemas.
Microsoft Power BI Data Analyst (PL-300) Practice Tests