Power BI 778 Power Query and Data Transformation 2

Question 1

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

Accepted Answer

Aggregates rows based on one or more grouping columns

Answer

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

Question 2

What is a 'Reference' query in Power Query?

Accepted Answer

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

Answer

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

Question 3

What does 'Fill Down' do in Power Query?

Accepted Answer

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

Answer

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

Question 4

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

Accepted Answer

Split Column

Answer

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

Question 5

What is query folding in Power Query?

Accepted Answer

Pushing transformation steps back to the data source to execute natively

Answer

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

Power BI 778 Practice Test

Power BI 778 Practice Test

Power BI 778 Power Query and Data Transformation 2