Practice Exams:

View All

Microsoft PL-300 Power Query Data Types Columns Grouping And Aggregation Practice Test

Skills 1.3 • 25 original questions

This Microsoft PL-300 Power BI Data Analyst practice test focuses on power query data types columns grouping and aggregation 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 operations scorecard redesign at Litware Finance, the report author must set column data types that support correct calculations, relationships, and storage. Which action most directly satisfies the requirement for the operations dashboard, analysis cycle 1?

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
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
Assign the appropriate data type to each column before loading it

Correct answer: E

Why: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

C: 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: set column data types that support correct calculations, relationships, and storage.

D: 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: set column data types that support correct calculations, relationships, and storage.

E: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: set column data types that support correct calculations, relationships, and storage.

Learning point: Assign the appropriate data type to each column before loading it

Question 2

Woodgrove Bank is revising its analytics solution during a customer analytics initiative. The team needs to derive or reshape column values during data preparation rather than fixing them manually later. Which Power BI action should the analytics lead choose for the customer report, analysis cycle 1?

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
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Create or transform columns in Power Query to shape values before load
Assign the appropriate data type to each column before loading it

Correct answer: D

Why: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: derive or reshape column values during data preparation rather than fixing them manually later.

Option review:

A: 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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

D: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

Learning point: Create or transform columns in Power Query to shape values before load

Question 3

A design review for the regional workspace, analysis cycle 1 at Blue Yonder Airlines identifies one required capability: summarize source rows by key before the data is loaded. Which implementation is the strongest fit?

Create or transform columns in Power Query to shape values before load
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
Assign the appropriate data type to each column before loading it
Create or select a stable key that uniquely identifies the appropriate side of a relationship

Correct answer: B

Why: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. This directly addresses the stated requirement: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

B: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. This directly addresses the stated requirement: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

Learning point: Group rows and apply aggregations in Power Query

Question 4

For the inventory model, analysis cycle 2, Contoso Retail wants the least indirect way to set column data types that support correct calculations, relationships, and storage. Which Power BI feature or action should the Power BI data analyst select?

Group rows and apply aggregations in Power Query
Create or transform columns in Power Query to shape values before load
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
Create or select a stable key that uniquely identifies the appropriate side of a relationship

Correct answer: C

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: set column data types that support correct calculations, relationships, and storage.

C: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: set column data types that support correct calculations, relationships, and storage.

D: 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: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

Learning point: Assign the appropriate data type to each column before loading it

Question 5

The self-service BI administrator at Litware Finance is comparing several approaches for a data-quality remediation. The chosen approach must derive or reshape column values during data preparation rather than fixing them manually later. Which option best meets that condition?

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
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
Merge queries to join columns from related tables or append queries to stack compatible rows

Correct answer: A

Option review:

A: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

D: 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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

Learning point: Create or transform columns in Power Query to shape values before load

Question 6

A support escalation at Woodgrove Bank has been narrowed to one requirement: summarize source rows by key before the data is loaded. Which configuration should be investigated first for the forecast report, analysis cycle 2?

Group rows and apply aggregations in Power Query
Create or transform columns in Power Query to shape values before load
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
Assign the appropriate data type to each column before loading it

Correct answer: A

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. This directly addresses the stated requirement: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

D: 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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

Learning point: Group rows and apply aggregations in Power Query

Question 7

An analytics governance review at Blue Yonder Airlines asks the report author to set column data types that support correct calculations, relationships, and storage. Which action aligns most directly with that requirement?

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
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure
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

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: set column data types that support correct calculations, relationships, and storage.

B: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

Learning point: Assign the appropriate data type to each column before loading it

Question 8

Before the executive report, analysis cycle 3 is released, the analytics team must derive or reshape column values during data preparation rather than fixing them manually later. Which Power BI implementation should be added?

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
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
Create or transform columns in Power Query to shape values before load

Correct answer: E

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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

E: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: derive or reshape column values during data preparation rather than fixing them manually later.

Learning point: Create or transform columns in Power Query to shape values before load

Question 9

Litware Finance is replacing a manual analytics process. The replacement must reliably summarize source rows by key before the data is loaded. Which choice should be implemented for the sales model, analysis cycle 3?

Enable or disable load and configure query loading so only required tables enter the model
Group rows and apply aggregations in Power Query
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
Merge queries to join columns from related tables or append queries to stack compatible rows

Correct answer: B

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

Learning point: Group rows and apply aggregations in Power Query

Question 10

Which Power BI action best matches this technical purpose for the finance semantic model, analysis cycle 4: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage.

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
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

Correct answer: B

Why: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

Option review:

A: 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: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

B: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

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: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

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: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

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: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

Learning point: Assign the appropriate data type to each column before loading it

Question 11

A runbook for the operations dashboard, analysis cycle 4 contains this description: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. Which Power BI feature or action belongs in the runbook?

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
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
Create or transform columns in Power Query to shape values before load

Correct answer: E

Why: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

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: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

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: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

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: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

D: 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: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

E: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

Learning point: Create or transform columns in Power Query to shape values before load

Question 12

During validation of the customer report, analysis cycle 4, the data analyst needs a capability that behaves as follows: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. Which choice is correct?

Group rows and apply aggregations in Power Query
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
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

Correct answer: A

Why: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. This directly addresses the stated requirement: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

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. This directly addresses the stated requirement: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

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: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

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: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

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: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

E: 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: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

Learning point: Group rows and apply aggregations in Power Query

Question 13

A stakeholder asks why a particular Power BI feature should be used for the regional workspace, analysis cycle 5. The required behavior is: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. Which action provides that behavior?

Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Enable or disable load and configure query loading so only required tables enter the model
Assign the appropriate data type to each column before loading it
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: C

Why: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

Option review:

A: 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: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

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: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

C: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

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: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

E: 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: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage..

Learning point: Assign the appropriate data type to each column before loading it

Question 14

The inventory model, analysis cycle 5 is moving to production at Woodgrove Bank. Which action should be approved when the goal is to derive or reshape column values during data preparation rather than fixing them manually later?

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
Group rows and apply aggregations in Power Query
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

Correct answer: D

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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

C: 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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

Learning point: Create or transform columns in Power Query to shape values before load

Question 15

A data analyst at Blue Yonder Airlines must satisfy this acceptance criterion for the service-level dashboard, analysis cycle 5: summarize source rows by key before the data is loaded. Which implementation is most appropriate?

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
Assign the appropriate data type to each column before loading it
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: A

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

E: 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: summarize source rows by key before the data is loaded.

Learning point: Group rows and apply aggregations in Power Query

Question 16

A regional reporting consolidation at Contoso Retail can proceed only after the team can set column data types that support correct calculations, relationships, and storage. What should the Power BI data analyst configure?

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
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

Correct answer: B

Option review:

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: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

Learning point: Assign the appropriate data type to each column before loading it

Question 17

The analytics team at Litware Finance has ruled out unrelated redesign work. Which action directly enables the team to derive or reshape column values during data preparation rather than fixing them manually later for the mobile report, analysis cycle 6?

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
Merge queries to join columns from related tables or append queries to stack compatible rows
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: 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: derive or reshape column values during data preparation rather than fixing them manually later.

B: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: derive or reshape column values during data preparation rather than fixing them manually later.

C: 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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

Learning point: Create or transform columns in Power Query to shape values before load

Question 18

An audit finding for the executive report, analysis cycle 6 says the current design cannot summarize source rows by key before the data is loaded. Which Power BI action most directly closes the gap?

Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
Separate transactional facts from descriptive dimensions and load them as fact and dimension tables
Group rows and apply aggregations in Power Query
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

Correct answer: C

Option review:

A: 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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

C: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. This directly addresses the stated requirement: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

Learning point: Group rows and apply aggregations in Power Query

Question 19

For the sales model, analysis cycle 7, the report author needs a repeatable solution that will set column data types that support correct calculations, relationships, and storage. Which option should replace the current ad hoc process?

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
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
Create or transform columns in Power Query to shape values before load

Correct answer: D

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: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

D: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

Learning point: Assign the appropriate data type to each column before loading it

Question 20

During a customer analytics initiative, Contoso Retail defines the desired outcome as follows: derive or reshape column values during data preparation rather than fixing them manually later. Which Power BI capability should the team use?

Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Assign the appropriate data type to each column before loading it
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

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: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

C: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: derive or reshape column values during data preparation rather than fixing them manually later.

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: derive or reshape column values during data preparation rather than fixing them manually later.

Learning point: Create or transform columns in Power Query to shape values before load

Question 21

A new requirement is added to the operations dashboard, analysis cycle 7: summarize source rows by key before the data is loaded. Which action should the BI developer take?

Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows
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
Group rows and apply aggregations in Power Query
Pivot, unpivot, or transpose the data to produce an analysis-friendly row-and-column structure

Correct answer: D

Option review:

A: 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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

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: summarize source rows by key before the data is loaded.

D: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. This directly addresses the stated requirement: summarize source rows by key before the data is loaded.

E: 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: summarize source rows by key before the data is loaded.

Learning point: Group rows and apply aggregations in Power Query

Question 22

Woodgrove Bank is troubleshooting an unexpected reporting result. The decisive requirement is to set column data types that support correct calculations, relationships, and storage. Which feature or configuration is most relevant?

Assign the appropriate data type to each column before loading it
Create or transform columns in Power Query to shape values before load
Group rows and apply aggregations in Power Query
Use a reference query when a dependent query should inherit upstream steps, and duplicate when an independent copy is required
Expand or transform semi-structured content such as JSON, XML, records, or lists into tabular columns and rows

Correct answer: A

Option review:

A: Correct data types are required for reliable aggregation, relationships, sorting, date logic, and efficient model storage. This directly addresses the stated requirement: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

Learning point: Assign the appropriate data type to each column before loading it

Question 23

A technical workshop for the regional workspace, analysis cycle 8 documents this behavior: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. Which Power BI choice is being described?

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
Enable or disable load and configure query loading so only required tables enter the model
Group rows and apply aggregations in Power Query
Create or select a stable key that uniquely identifies the appropriate side of a relationship

Correct answer: B

Why: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

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: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

B: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage. This directly addresses the stated requirement: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

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: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

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: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

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: Power Query column transformations can split, replace, extract, combine, or derive values during the data preparation stage..

Learning point: Create or transform columns in Power Query to shape values before load

Question 24

The data analyst must identify the Power BI capability that provides this function: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. Which answer is correct for the inventory model, analysis cycle 8?

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
Assign the appropriate data type to each column before loading it
Group rows and apply aggregations in Power Query
Create or transform columns in Power Query to shape values before load

Correct answer: D

Why: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. This directly addresses the stated requirement: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

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: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

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: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

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: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

D: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum. This directly addresses the stated requirement: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

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: Group By reduces or summarizes rows by one or more keys and can calculate aggregations such as sum, count, minimum, or maximum..

Learning point: Group rows and apply aggregations in Power Query

Question 25

A modernization plan for the service-level dashboard, analysis cycle 9 requires the team to set column data types that support correct calculations, relationships, and storage. Which Power BI action is the clearest fit?

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
Enable or disable load and configure query loading so only required tables enter the model
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: D

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: set column data types that support correct calculations, relationships, and storage.

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: set column data types that support correct calculations, relationships, and storage.

Learning point: Assign the appropriate data type to each column before loading it

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: