Microsoft Certified Data Analyst Associate Power Query and Data Transformation

Question 1

What language is used for transformations in Power Query?

Accepted Answer

M (Power Query Formula Language)

Answer

DAX

Answer

SQL

Answer

Python

Question 2

What does the 'Merge Queries' operation in Power Query do?

Accepted Answer

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

Answer

Appends rows from one table to another

Answer

Combines columns from the same table

Answer

Merges duplicate rows into one

Question 3

What does the 'Append Queries' operation in Power Query do?

Accepted Answer

Stacks rows from multiple tables into a single table

Answer

Joins two tables on a common key

Answer

Adds new calculated columns to a table

Answer

Appends a SQL query to an M script

Question 4

What is query folding in Power Query?

Accepted Answer

The process of translating M transformations into native source queries (e.g., SQL) for execution at the source

Answer

Collapsing multiple queries into one in the Query Editor

Answer

Folding long M code into a single line

Answer

Caching query results for faster load

Question 5

What does the 'Unpivot Columns' transformation do in Power Query?

Accepted Answer

Converts multiple attribute columns into two columns: Attribute and Value

Answer

Rotates row data into column headers

Answer

Removes duplicate column headers

Answer

Transposes the entire table

Question 6

How can you reference a parameter in a Power Query M expression?

Accepted Answer

By typing the parameter name directly as a value in the expression

Answer

Using @ symbol prefix

Answer

Using the #{} syntax

Answer

By importing it with a SQL variable