Microsoft Certified Data Analyst Associate Power Query and Data Transformation 3

Question 1

What happens when you disable 'Include in Report Refresh' for a query in Power Query?

Accepted Answer

The query is excluded from scheduled and manual dataset refreshes

Answer

The query is deleted from the model

Answer

The query runs only during initial load

Answer

The query output is cached permanently

Question 2

What is the 'List.Generate' function used for in Power Query M?

Accepted Answer

Generating a list of values by iterating with an initial state, condition, and transformation

Answer

Creating a list of column names from a table

Answer

Listing all available data sources

Answer

Generating a sequential number list only

Question 3

Which Power Query join type returns only rows that match in both tables?

Accepted Answer

Inner

Answer

Left Outer

Answer

Full Outer

Answer

Right Anti

Question 4

What does the 'Conditional Column' feature in Power Query allow you to do?

Accepted Answer

Add a new column with values determined by if/then/else rules without writing M code

Answer

Filter rows based on a condition

Answer

Create a column that is hidden unless a condition is met

Answer

Conditionally change data types

Question 5

What is the benefit of enabling 'Fast Combine' (Ignore Privacy Levels) in Power Query?

Accepted Answer

It allows combining data from sources with different privacy levels, bypassing firewall checks for performance

Answer

It speeds up query folding for SQL sources

Answer

It disables column profiling for faster load

Answer

It compresses the dataset during refresh

Question 6

What Power Query operation would you use to split a column containing 'FirstName LastName' into two separate columns?

Accepted Answer

Split Column by Delimiter

Answer

Merge Columns

Answer

Unpivot Column

Answer

Extract Values