100% Latest & Updated Microsoft PL-300 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 120
A product code includes a region and SKU separated by a hyphen that must become separate fields. A specific ongoing problem has appeared: Unexpected delimiter counts can misassign parts. Which safeguard most directly addresses it?
- Flag source rows that violate the expected code format.
- Track the rate of conversion errors in refresh diagnostics.
- Monitor source schema and request limitations before refresh scheduling.
- Confirm parameter values and credentials before deployment and refresh.
Explanation
Correct Answer
A:A validation rule catches malformed composite identifiers.
Incorrect Answers
B:A rising error rate indicates a new source-quality problem. A validation rule catches malformed composite identifiers.
C:OData capabilities and access limits can affect reliable refresh; a validation rule catches malformed composite identifiers.
D:Environment-aware validation prevents accidental cross-environment connections. A validation rule catches malformed composite identifiers.
Question 121
A REST API returns JSON objects with nested customer and order records. Which Power BI approach most directly satisfies this requirement?
- Duplicate the query to copy its current transformation steps.
- Normalize period text into a proper date key at month grain.
- Expand JSON records and lists into the required tabular fields.
- Pivot a categorical attribute into separate columns.
Explanation
Correct Answer
C:Power Query can transform semi-structured JSON to tables by expanding structures.
Incorrect Answers
A:Duplicate creates a separate query definition rather than a live dependent reference. Power Query can transform semi-structured JSON to tables by expanding structures.
B:A consistent date column supports reliable relationships and time filtering; Power Query can transform semi-structured JSON to tables by expanding structures.
D:Pivot turns distinct attribute values into columns with appropriate aggregation; Power Query can transform semi-structured JSON to tables by expanding structures.
Question 122
A vendor API supplies JSON arrays of products with nested price fields. The selected approach is: Expand JSON records and lists into the required tabular fields. Which implementation step puts it into practice?
- Convert list and record nodes to tables then expand selected fields.
- Create Reference queries and add downstream transformations only where needed.
- Validate uniqueness and missing matches before defining relationships.
- Choose the metric-name column and aggregation when pivoting measure values.
Explanation
Correct Answer
A:The analyst should choose fields and preserve parent keys.
Incorrect Answers
B:Common cleaning logic remains centralized. It does not implement the needed solution: expand json records and lists into the required tabular fields.
C:A nonunique dimension key can cause an unexpected many-to-many relation. It does not implement the needed solution: expand json records and lists into the required tabular fields.
D:Duplicate entity-metric combinations require a deliberate aggregation rule. It does not implement the needed solution: expand json records and lists into the required tabular fields.
Question 123
A REST API returns JSON objects with nested customer and order records. The chosen solution is: Expand JSON records and lists into the required tabular fields. Which verification best demonstrates that it meets the requirement?
- Reconcile unique key counts and downstream aggregate totals.
- Verify the imported IDs match the source strings exactly.
- Count valid unique keys after handling missing records.
- Check expanded row grain and field values against known API objects.
Explanation
Correct Answer
D:Array expansion may intentionally create multiple rows per parent.
Incorrect Answers
A:Business totals must reflect the intended distinct records. That check does not verify the result required here: check expanded row grain and field values against known api objects.
B:Distinct ID mappings and joins depend on preserving values. That check does not verify the result required here: check expanded row grain and field values against known api objects.
C:The cleaned dimension should have an expected usable key population. That check does not verify the result required here: check expanded row grain and field values against known api objects.
Question 124
A REST API returns JSON objects with nested customer and order records. A specific ongoing problem has appeared: Nested arrays may unexpectedly multiply rows. Which safeguard most directly addresses it?
- Confirm key uniqueness and row counts after each expansion.
- Recheck privacy classifications when a source or connector changes.
- Monitor semantic model refresh history and refresh failure alerts.
- Monitor invalid-value rates and alert the data owner.
Explanation
Correct Answer
A:Expansion can create duplicates or alter the intended grain.
Incorrect Answers
B:New sources and permissions can change the relevant privacy boundary. Expansion can create duplicates or alter the intended grain.
C:Import copies can become stale; monitoring refresh success catches missing updates; expansion can create duplicates or alter the intended grain.
D:Recurring rule checks support source correction. Expansion can create duplicates or alter the intended grain.
Question 125
A report receives a transposed grid whose data fields are listed down rows rather than across headers. Which Power BI approach most directly satisfies this requirement?
- Disable load for the staging query while leaving its dependents enabled.
- Merge Power Query queries by the matching lookup keys.
- Normalize period text into a proper date key at month grain.
- Transpose the table before promoting the intended headers.
Explanation
Correct Answer
D:Transposition swaps row and column orientation for a consistently rotated layout.
Incorrect Answers
A:An intermediate query need not load duplicate tables to the model. Transposition swaps row and column orientation for a consistently rotated layout.
B:Merge performs a horizontal join between related tables; transposition swaps row and column orientation for a consistently rotated layout.
C:A consistent date column supports reliable relationships and time filtering. Transposition swaps row and column orientation for a consistently rotated layout.
Question 126
A vendor exports a table whose first column is a field name and each following column is a record. The selected approach is: Transpose the table before promoting the intended headers. Which implementation step puts it into practice?
- Choose the metric-name column and aggregation when pivoting measure values.
- Use Transpose then promote the appropriate first row to headers.
- Apply foldable filters and inspect the native query where available.
- Align names and types before appending the regional query outputs.
Explanation
Correct Answer
B:The sequence aligns record fields with table columns.
Incorrect Answers
A:Duplicate entity-metric combinations require a deliberate aggregation rule. It does not implement the needed solution: transpose the table before promoting the intended headers.
C:Native query diagnostics reveal whether a step delegates work to the source. It does not implement the needed solution: transpose the table before promoting the intended headers.
D:The schemas must correspond to avoid unexpected null columns. It does not implement the needed solution: transpose the table before promoting the intended headers.
Question 127
A report receives a transposed grid whose data fields are listed down rows rather than across headers. The chosen solution is: Transpose the table before promoting the intended headers. Which verification best demonstrates that it meets the requirement?
- Measure interactive responsiveness and confirm values after scheduled refresh.
- Inspect the distribution and null percentages for the relevant column.
- Test a service-side refresh using the configured gateway.
- Compare transformed fields and records to sample source values.
Explanation
Correct Answer
D:Wrong header promotion can silently shift values.
Incorrect Answers
A:Both report speed and currency after the planned refresh demonstrate whether Import meets the stated priorities. That check does not verify the result required here: compare transformed fields and records to sample source values.
B:These statistics drive cleaning rather than arbitrary replacement. That check does not verify the result required here: compare transformed fields and records to sample source values.
C: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: compare transformed fields and records to sample source values.
Question 128
A report receives a transposed grid whose data fields are listed down rows rather than across headers. A specific ongoing problem has appeared: A changed number of source fields could break the transform. Which safeguard most directly addresses it?
- Track shared semantic model changes and test dependent report measures.
- Review DirectLake support and monitor fallback or guardrail conditions.
- Recheck privacy classifications when a source or connector changes.
- Validate header names and schema after transposition.
Explanation
Correct Answer
D:New field rows can alter resulting column structures.
Incorrect Answers
A:Thin reports inherit upstream semantics and should be regression tested; new field rows can alter resulting column structures.
B:DirectLake has feature and capacity constraints; detecting changes avoids assuming every query uses the intended mode. New field rows can alter resulting column structures.
C:New sources and permissions can change the relevant privacy boundary; new field rows can alter resulting column structures.
Question 129
An analyst wants a cleaned base query and two dependent queries that inherit its future changes. Which Power BI approach most directly satisfies this requirement?
- Configure incremental refresh using RangeStart and RangeEnd policies.
- Unpivot repeated period columns into attribute-value rows.
- Split a source column using a documented delimiter.
- Reference the base query to reuse its transformations.
Explanation
Correct Answer
D:A reference creates a dependent query that follows changes in the original.
Incorrect Answers
A:Incremental refresh partitions historical and refreshed date windows under supported conditions. A reference creates a dependent query that follows changes in the original.
B:Unpivot converts wide period fields into tidy rows for filtering and analysis; a reference creates a dependent query that follows changes in the original.
C:A consistent delimiter allows separate attributes to be extracted. A reference creates a dependent query that follows changes in the original.
Question 130
A finance team needs multiple report-specific aggregations from one curated Power Query base. The selected approach is: Reference the base query to reuse its transformations. Which implementation step puts it into practice?
- Use Split Column by Delimiter with correct split-at and type rules.
- Define ordered if-then conditions and a default outcome.
- Create Reference queries and add downstream transformations only where needed.
- Choose the metric-name column and aggregation when pivoting measure values.
Explanation
Correct Answer
C:Common cleaning logic remains centralized.
Incorrect Answers
A:The transform should respect codes that may contain multiple delimiters. It does not implement the needed solution: reference the base query to reuse its transformations.
B:Rule ordering and fallback values determine the classifications. It does not implement the needed solution: reference the base query to reuse its transformations.
D:Duplicate entity-metric combinations require a deliberate aggregation rule. It does not implement the needed solution: reference the base query to reuse its transformations.
Microsoft Power BI Data Analyst (PL-300) Practice Tests