Practice Exams:

View All

Microsoft PL-300 Pivot Unpivot Transpose And Semi Structured Data Practice Test

Skills 1.3 • 25 original questions

This Microsoft PL-300 Power BI Data Analyst practice test focuses on pivot unpivot transpose and semi structured data through original scenario-based questions aligned to the skills measured as of April 20, 2026. Use the full ExamSnap PL-300 collection for broader practice across all current skill areas. For broader exam preparation, review the Microsoft PL-300 Exam Dumps page.

Instructions: Select the best answer for each question. Review the explanation after answering; each distractor includes a reason it is not the best choice for that scenario.

Question 1

During a customer analytics initiative at Adventure Works, the data analyst must reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which action most directly satisfies the requirement for the customer report, analysis cycle 1?

Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Create or transform columns in Power Query to shape values before load
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Group rows and apply aggregations in Power Query

Correct answer: B

Why: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Option review:

A: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

B: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

C: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

D: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

E: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 2

Proseware Services is revising its analytics solution during a semantic model modernization. The team needs to turn nested or semi-structured content into a usable table. Which Power BI action should the report author choose for the regional workspace, analysis cycle 1?

Enable or disable load and configure query loading so only required tables enter the model
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Assign the appropriate data type to each column before loading it
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Correct answer: E

Why: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: turn nested or semi-structured content into a usable table.

Option review:

A: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

B: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

C: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

D: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

E: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 3

A design review for the inventory model, analysis cycle 2 at Fourth Coffee identifies one required capability: reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which implementation is the strongest fit?

Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Enable or disable load and configure query loading so only required tables enter the model
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Correct answer: D

Option review:

A: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

B: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

C: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

D: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

E: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 4

For the service-level dashboard, analysis cycle 2, Fabrikam Manufacturing wants the least indirect way to turn nested or semi-structured content into a usable table. Which Power BI feature or action should the BI developer select?

Create or select a stable key that uniquely identifies the appropriate side of a relationship
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Assign the appropriate data type to each column before loading it
Group rows and apply aggregations in Power Query
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Correct answer: E

Option review:

A: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

B: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

C: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

D: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 5

The Power BI data analyst at Adventure Works is comparing several approaches for a finance dashboard refresh. The chosen approach must reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which option best meets that condition?

Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Enable or disable load and configure query loading so only required tables enter the model
Merge queries to join columns from related tables or append queries to stack compatible rows
Group rows and apply aggregations in Power Query

Correct answer: A

Option review:

A: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

B: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

D: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 6

A support escalation at Proseware Services has been narrowed to one requirement: turn nested or semi-structured content into a usable table. Which configuration should be investigated first for the mobile report, analysis cycle 3?

Create or transform columns in Power Query to shape values before load
Merge queries to join columns from related tables or append queries to stack compatible rows
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required

Correct answer: D

Option review:

A: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

B: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

C: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

D: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: turn nested or semi-structured content into a usable table.

E: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 7

An analytics governance review at Fourth Coffee asks the data analyst to reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which action aligns most directly with that requirement?

Group rows and apply aggregations in Power Query
Assign the appropriate data type to each column before loading it
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Create or transform columns in Power Query to shape values before load

Correct answer: D

Option review:

A: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

B: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

C: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

E: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 8

Before the sales model, analysis cycle 4 is released, the analytics team must turn nested or semi-structured content into a usable table. Which Power BI implementation should be added?

Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Enable or disable load and configure query loading so only required tables enter the model
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Assign the appropriate data type to each column before loading it
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Correct answer: E

Option review:

A: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

B: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 9

Adventure Works is replacing a manual analytics process. The replacement must reliably reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which choice should be implemented for the finance semantic model, analysis cycle 5?

Assign the appropriate data type to each column before loading it
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Create or transform columns in Power Query to shape values before load
Create or select a stable key that uniquely identifies the appropriate side of a relationship

Correct answer: C

Option review:

A: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

C: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

D: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

E: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 10

Which Power BI action best matches this technical purpose for the operations dashboard, analysis cycle 5: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model.

Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Create or transform columns in Power Query to shape values before load
Assign the appropriate data type to each column before loading it
Enable or disable load and configure query loading so only required tables enter the model
Create or select a stable key that uniquely identifies the appropriate side of a relationship

Correct answer: A

Why: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

Option review:

A: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

B: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

C: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

D: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

E: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 11

A runbook for the customer report, analysis cycle 6 contains this description: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. Which Power BI feature or action belongs in the runbook?

Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Merge queries to join columns from related tables or append queries to stack compatible rows
Enable or disable load and configure query loading so only required tables enter the model
Create or transform columns in Power Query to shape values before load
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Correct answer: E

Why: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

Option review:

A: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

B: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

C: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

D: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

E: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 12

During validation of the regional workspace, analysis cycle 6, the self-service BI administrator needs a capability that behaves as follows: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. Which choice is correct?

Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Create or transform columns in Power Query to shape values before load
Enable or disable load and configure query loading so only required tables enter the model
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables

Correct answer: A

Option review:

B: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

C: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

E: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 13

A stakeholder asks why a particular Power BI feature should be used for the inventory model, analysis cycle 7. The required behavior is: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. Which action provides that behavior?

Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Create or transform columns in Power Query to shape values before load
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Correct answer: E

Why: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

Option review:

A: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

B: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

C: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

D: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 14

The service-level dashboard, analysis cycle 7 is moving to production at Proseware Services. Which action should be approved when the goal is to turn nested or semi-structured content into a usable table?

Create or select a stable key that uniquely identifies the appropriate side of a relationship
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Assign the appropriate data type to each column before loading it
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables

Correct answer: B

Option review:

B: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: turn nested or semi-structured content into a usable table.

D: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

E: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 15

A data analyst at Fourth Coffee must satisfy this acceptance criterion for the forecast report, analysis cycle 8: reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which implementation is most appropriate?

Assign the appropriate data type to each column before loading it
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Enable or disable load and configure query loading so only required tables enter the model
Group rows and apply aggregations in Power Query

Correct answer: C

Option review:

B: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

D: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 16

A operations scorecard redesign at Fabrikam Manufacturing can proceed only after the team can turn nested or semi-structured content into a usable table. What should the BI developer configure?

Merge queries to join columns from related tables or append queries to stack compatible rows
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Group rows and apply aggregations in Power Query

Correct answer: B

Option review:

A: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

C: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

D: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

E: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 17

The analytics team at Adventure Works has ruled out unrelated redesign work. Which action directly enables the team to reshape a cross-tab or attribute/value structure into a form suitable for analysis for the executive report, analysis cycle 9?

Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Enable or disable load and configure query loading so only required tables enter the model
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Create or transform columns in Power Query to shape values before load

Correct answer: A

Option review:

B: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

C: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

D: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 18

An audit finding for the sales model, analysis cycle 9 says the current design cannot turn nested or semi-structured content into a usable table. Which Power BI action most directly closes the gap?

Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Create or transform columns in Power Query to shape values before load
Merge queries to join columns from related tables or append queries to stack compatible rows

Correct answer: C

Option review:

A: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

B: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

C: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: turn nested or semi-structured content into a usable table.

D: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

E: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 19

For the finance semantic model, analysis cycle 10, the data analyst needs a repeatable solution that will reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which option should replace the current ad hoc process?

Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Merge queries to join columns from related tables or append queries to stack compatible rows
Create or transform columns in Power Query to shape values before load
Create or select a stable key that uniquely identifies the appropriate side of a relationship
Assign the appropriate data type to each column before loading it

Correct answer: A

Option review:

B: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

E: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 20

During a sales analytics project, Fabrikam Manufacturing defines the desired outcome as follows: turn nested or semi-structured content into a usable table. Which Power BI capability should the team use?

Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Merge queries to join columns from related tables or append queries to stack compatible rows
Assign the appropriate data type to each column before loading it
Group rows and apply aggregations in Power Query
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables

Correct answer: A

Option review:

A: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: turn nested or semi-structured content into a usable table.

E: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 21

A new requirement is added to the customer report, analysis cycle 11: reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which action should the analytics lead take?

Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Merge queries to join columns from related tables or append queries to stack compatible rows
Create or select a stable key that uniquely identifies the appropriate side of a relationship

Correct answer: C

Option review:

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 22

Proseware Services is troubleshooting an unexpected reporting result. The decisive requirement is to turn nested or semi-structured content into a usable table. Which feature or configuration is most relevant?

Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Enable or disable load and configure query loading so only required tables enter the model
Merge queries to join columns from related tables or append queries to stack compatible rows
Assign the appropriate data type to each column before loading it

Correct answer: A

Option review:

C: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

D: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

E: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: turn nested or semi-structured content into a usable table.

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 23

A technical workshop for the inventory model, analysis cycle 12 documents this behavior: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. Which Power BI choice is being described?

Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Merge queries to join columns from related tables or append queries to stack compatible rows
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Assign the appropriate data type to each column before loading it
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required

Correct answer: A

Why: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

Option review:

A: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. This directly addresses the stated requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

B: Merge performs a join by key, whereas append combines rows from tables with compatible structures. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

C: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

D: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

E: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly..

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 24

The self-service BI administrator must identify the Power BI capability that provides this function: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. Which answer is correct for the service-level dashboard, analysis cycle 12?

Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Enable or disable load and configure query loading so only required tables enter the model
Create or select a stable key that uniquely identifies the appropriate side of a relationship

Correct answer: B

Option review:

A: A star schema places measurable events in fact tables and descriptive attributes in dimensions, improving usability and model behavior. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

B: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model. This directly addresses the stated requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

C: Pivoting and unpivoting reshape attribute/value arrangements, while transpose exchanges rows and columns when the source layout is oriented incorrectly. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

E: Relationships depend on reliable keys; a dimension-side key should normally be unique and compatible with the matching foreign key. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: Semi-structured sources need to be navigated and expanded so nested values become a table that Power BI can model..

Learning point: Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Question 25

A modernization plan for the forecast report, analysis cycle 13 requires the team to reshape a cross-tab or attribute/value structure into a form suitable for analysis. Which Power BI action is the clearest fit?

Create or transform columns in Power Query to shape values before load
Assign the appropriate data type to each column before loading it
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Enable or disable load and configure query loading so only required tables enter the model

Correct answer: C

Option review:

A: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

D: Reference queries depend on another query result, while duplicate copies the existing steps and then evolves independently. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

E: Query load settings prevent staging or helper queries from unnecessarily becoming model tables while still allowing them to support downstream transformations. It is useful in another Power BI scenario, but it does not most directly satisfy this requirement: reshape a cross-tab or attribute/value structure into a form suitable for analysis.

Learning point: Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Related posts: