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 is Power Query used for in Power BI?

    Answer: Connecting to data sources and transforming data before loading

    Power Query is the ETL (Extract, Transform, Load) engine in Power BI used to connect, clean, and shape data before analysis.

  2. What language do Power Query transformations use behind the scenes?

    Answer: M (Power Query Formula Language)

    Power Query uses M language, a functional language that defines every transformation step applied to your data.

  3. Which Power Query step removes rows where a specified column's value is null?

    Answer: Filter Rows

    Filter Rows allows you to filter out rows based on conditions, including removing rows where a column value is null.

  4. What does 'Append Queries' do in Power Query?

    Answer: Stacks rows from multiple tables vertically into one table

    Append Queries combines tables by stacking their rows on top of each other, similar to UNION ALL in SQL.

  5. What does 'Merge Queries' do in Power Query?

    Answer: Joins two tables horizontally on a common key column

    Merge Queries performs a join between two tables based on matching key columns, similar to a SQL JOIN.

  6. What is the purpose of the 'Unpivot Columns' transformation in Power Query?

    Answer: Converts multiple columns into attribute-value row pairs

    Unpivot Columns rotates selected columns into rows, creating an attribute column and a value column for each combination.

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