Microsoft Certified Data Analyst Associate Power Query and Data Transformation 2

Question 1

What is a Power Query function?

Accepted Answer

A reusable M query that accepts parameters and returns a value or table

Answer

A DAX function called from Power Query

Answer

A built-in connector for external APIs

Answer

A SQL stored procedure called during refresh

Question 2

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

Accepted Answer

Aggregates rows with the same key column values using operations like Sum, Count, or Average

Answer

Sorts rows by a column value

Answer

Groups multiple queries into a folder

Answer

Applies conditional formatting by group

Question 3

Which data type in Power Query should be used for columns that will be used in DAX date calculations?

Accepted Answer

Date or Date/Time

Answer

Text

Answer

Whole Number

Answer

Duration

Question 4

What is the purpose of the 'Applied Steps' pane in Power Query Editor?

Accepted Answer

It lists all transformation steps applied to the query in order, allowing editing or deletion

Answer

It shows the query execution plan

Answer

It displays the SQL generated by query folding

Answer

It shows data quality errors per column

Question 5

What does enabling 'Column Quality' in Power Query Editor display?

Accepted Answer

Percentage of valid, error, and empty values for each column

Answer

Data type icons for each column

Answer

A histogram of value distribution

Answer

The number of unique values per column

Question 6

What is the 'Table.TransformColumnTypes' function used for in M language?

Accepted Answer

Changing the data types of one or more columns in a table

Answer

Renaming columns in a table

Answer

Filtering rows based on column values

Answer

Splitting a column into multiple columns