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 is a Power Query function?
Answer: A reusable M query that accepts parameters and returns a value or table
Power Query functions are reusable M queries parameterized to accept inputs, enabling you to apply the same transformation logic to multiple data sources.
What does the 'Group By' transformation do in Power Query?
Answer: Aggregates rows with the same key column values using operations like Sum, Count, or Average
Group By aggregates data by specified key columns, computing summary statistics like sum or count for each group.
Which data type in Power Query should be used for columns that will be used in DAX date calculations?
Answer: Date or Date/Time
Columns used in DAX time intelligence functions must be of the Date or Date/Time data type for proper calendar-based calculations.
What is the purpose of the 'Applied Steps' pane in Power Query Editor?
Answer: It lists all transformation steps applied to the query in order, allowing editing or deletion
The Applied Steps pane records every transformation step as a named M expression, letting you review, reorder, or delete individual steps.
What does enabling 'Column Quality' in Power Query Editor display?
Answer: Percentage of valid, error, and empty values for each column
Column Quality shows the percentage of valid, error, and empty values in each column, helping you quickly identify data quality issues.
What is the 'Table.TransformColumnTypes' function used for in M language?
Answer: Changing the data types of one or more columns in a table
Table.TransformColumnTypes changes the data type of specified columns, which is automatically generated when you set types in the Power Query UI.
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