Power BI 778 Power Query and Data Transformation

Question 1

What is Power Query used for in Power BI?

Accepted Answer

Connecting to data sources and transforming data before loading

Answer

Writing DAX measures

Answer

Creating visualizations

Answer

Publishing reports to the Power BI Service

Question 2

What language do Power Query transformations use behind the scenes?

Accepted Answer

M (Power Query Formula Language)

Answer

DAX

Answer

SQL

Answer

Python

Question 3

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

Accepted Answer

Filter Rows

Answer

Remove Duplicates

Answer

Remove Errors

Answer

Fill Down

Question 4

What does 'Append Queries' do in Power Query?

Accepted Answer

Stacks rows from multiple tables vertically into one table

Answer

Merges two tables by matching on a key column

Answer

Joins two tables side by side

Answer

Removes duplicate rows across tables

Question 5

What does 'Merge Queries' do in Power Query?

Accepted Answer

Joins two tables horizontally on a common key column

Answer

Stacks rows from two tables vertically

Answer

Combines all columns from all tables

Answer

Removes matching rows from one table

Question 6

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

Accepted Answer

Converts multiple columns into attribute-value row pairs

Answer

Converts row data into column headers

Answer

Removes selected columns from a table

Answer

Transposes rows and columns