Power Query and Data Transformation Flashcards
6 cards from real Microsoft Certified Data Analyst Associate practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Power Query and Data Transformation flashcards as text
What language is used for transformations in Power Query?
Answer: M (Power Query Formula Language)
Power Query uses the M language (Power Query Formula Language) to define all data transformation steps.
What does the 'Merge Queries' operation in Power Query do?
Answer: Joins two tables based on matching columns, similar to a SQL JOIN
Merge Queries combines two tables based on matching key columns using join types such as Left Outer, Inner, or Full Outer.
What does the 'Append Queries' operation in Power Query do?
Answer: Stacks rows from multiple tables into a single table
Append Queries combines rows from two or more tables with matching column structures into one table, similar to SQL UNION.
What is query folding in Power Query?
Answer: The process of translating M transformations into native source queries (e.g., SQL) for execution at the source
Query folding occurs when Power Query translates transformation steps into native SQL (or other source queries) so the source executes them instead of the engine, improving performance.
What does the 'Unpivot Columns' transformation do in Power Query?
Answer: Converts multiple attribute columns into two columns: Attribute and Value
Unpivoting converts wide-format data (many columns) into a long format with an Attribute column and a Value column, making it easier to analyze.
How can you reference a parameter in a Power Query M expression?
Answer: By typing the parameter name directly as a value in the expression
Power Query parameters are referenced by their name directly in M expressions, and they appear as named values in the query context.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Passing score, renewal, fees, time limit, score validity, retake fee, exam information · verified Oct 2026
- pearsonvue.com — Test delivery · verified Oct 2026