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

Power Query functions are reusable M queries parameterized to accept inputs, enabling you to apply the same transformation logic to multiple data sources.

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

Group By aggregates data by specified key columns, computing summary statistics like sum or count for each 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

Columns used in DAX time intelligence functions must be of the Date or Date/Time data type for proper calendar-based calculations.

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

The Applied Steps pane records every transformation step as a named M expression, letting you review, reorder, or delete individual steps.

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

Column Quality shows the percentage of valid, error, and empty values in each column, helping you quickly identify data quality issues.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Power Query and Data Transformation 2