PL-300 Prepare the data Practice Question
You need to combine data from three different SharePoint lists into a single table for analysis. The lists have different column names but contain similar data. What is the best approach in Power Query?
⚠ Common exam trap
Many candidates confuse 'Append' (row stacking) with 'Merge' (column joining), often choosing Merge because they think they need a 'common key' to combine data, but the question explicitly states the lists have different column names, making a key-based join inappropriate.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use 'Append Queries' and then rename columns to match.
Append Queries is the correct approach because it stacks rows from multiple tables (SharePoint lists) into a single table, which is exactly what you need when combining data with similar structures but different column names. After appending, you can rename columns to unify the schema. This is the standard Power Query method for row-level concatenation of tables.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use 'Unpivot Columns' to transform the data.
Why it's wrong here
Unpivot Columns is a reshaping transformation that converts selected columns into attribute-value pairs, thereby transforming the data from a wide format to a long format. This operation works only on a single table and cannot bring in records from other SharePoint lists. Applying unpivot here would not combine the three lists; it would merely reorganize the columns of one table, potentially destroying the row-level granularity needed for a unified dataset.
- ✗
Use 'Group By' to combine values.
Why it's wrong here
Group By is an aggregation operation that groups rows within a single table based on key columns and computes summary statistics like sums, counts, or averages. It does not concatenate data from multiple tables or move records between queries, so it cannot merge rows from three SharePoint lists into one comprehensive table. Using Group By on a single list would collapse detail rows and lose the data you are trying to combine, making it entirely inappropriate for this requirement.
- ✓
Use 'Append Queries' and then rename columns to match.
Why this is correct
Append Queries is the correct operation because it stacks rows from multiple queries vertically, which is exactly what you need when combining three SharePoint lists that contain similar record types. When appending, Power Query matches columns by name, so after the append you may need to rename columns in the individual queries to ensure a uniform schema; otherwise you can end up with mismatched columns or nulls. This method preserves all source rows and yields a single consolidated table that is ready for further transformation.
- ✗
Use 'Merge Queries' on a common key column.
Why it's wrong here
Merge Queries performs a horizontal join between two tables by matching rows on a common key column, combining columns from the right table into the left table. This is fundamentally different from stacking rows: it increases the number of columns (and can multiply rows in many-to-many joins) rather than increasing the number of rows in a single vertical list. Since the requirement is to combine the row sets of three SharePoint lists, merging would produce a wide, join-based result and would also require a meaningful key column, which is likely nonexistent or inconsistent across the lists.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 524 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.