Practice Test GeeksPower BI 778 Practice Test
← All Power BI 778 Flashcard Decks

Power Query and Data Transformation Flashcards

6 cards from real Power BI 778 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

  1. What does the 'Group By' transformation do in Power Query?

    Answer: Aggregates rows based on one or more grouping columns

    Group By in Power Query aggregates data by specified columns, similar to GROUP BY in SQL.

  2. What is a 'Reference' query in Power Query?

    Answer: A query that uses another query as its source without duplicating the data load

    A Reference query points to another query as its starting point, sharing the same data load without running the source query twice.

  3. What does 'Fill Down' do in Power Query?

    Answer: Replaces null values with the value from the cell above in the same column

    Fill Down replaces null values in a column by carrying forward the most recent non-null value from the rows above.

  4. Which Power Query transformation splits a column into multiple columns based on a delimiter?

    Answer: Split Column

    Split Column divides a column into multiple columns using a specified delimiter like a comma, space, or custom character.

  5. What is query folding in Power Query?

    Answer: Pushing transformation steps back to the data source to execute natively

    Query folding allows Power Query to translate transformation steps into native source queries (e.g., SQL), improving performance by reducing data transferred.

  6. What does the 'Pivot Column' transformation do in Power Query?

    Answer: Converts attribute-value rows into separate columns

    Pivot Column turns unique values from one column into new column headers, essentially transposing key-value pairs into a wide table.

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

  1. learn.microsoft.com — Renewal, retake fee, passing score, exam format, test delivery, fees, time limit, exam information · verified Oct 2026