Microsoft Power BI Power Query and Data Transformation

Question 1

What language does Power Query use for its advanced editor transformations?

Accepted Answer

M language (M formula language)

Answer

DAX

Answer

SQL

Answer

Python

Question 2

What does the 'Remove Duplicates' step in Power Query do?

Accepted Answer

Keeps only the first occurrence of each duplicate row based on selected columns

Answer

Removes rows with null values

Answer

Removes duplicate column names

Answer

Deletes rows that appear more than twice

Question 3

In Power Query, what does 'Unpivot Columns' do to a table?

Accepted Answer

Converts selected column headers and their values into attribute-value rows

Answer

Transposes rows and columns

Answer

Removes selected columns from the table

Answer

Pivots data from rows into columns

Question 4

What is a 'Query Dependency' in Power Query?

Accepted Answer

A relationship between queries where one query references or is built upon another

Answer

A required parameter for every query

Answer

An error that occurs when a query fails

Answer

A scheduled refresh dependency

Question 5

Which Power Query step type allows you to combine rows from two tables with the same columns?

Accepted Answer

Append Queries

Answer

Merge Queries

Answer

Join Queries

Answer

Union Queries

Question 6

What does 'Merge Queries' do in Power Query?

Accepted Answer

Joins two tables based on matching key columns, similar to a SQL JOIN

Answer

Combines rows from two tables by stacking them

Answer

Merges two .pbix files together

Answer

Combines multiple columns into one