Power BI 778 Power Query and Data Transformation 3

Question 1

What does 'Promote Headers' do in Power Query?

Accepted Answer

Uses the first row of data as the column headers

Answer

Promote Headers takes the first row of the dataset and converts it into the column header names.

Question 2

Which data type in Power Query stores whole numbers without decimal places?

Accepted Answer

Whole Number

Answer

Whole Number data type in Power Query stores integers (positive and negative whole numbers) without any decimal precision.

Question 3

What happens when you set a query's load setting to 'Enable Load' off in Power Query?

Accepted Answer

The query runs but its results are not loaded into the data model

Answer

Disabling 'Enable Load' keeps the query available as a staging or reference query without adding its data to the final model.

Question 4

What is the purpose of a 'Parameter' in Power Query?

Accepted Answer

A variable value that can be used dynamically within query steps

Answer

A Power Query Parameter is a reusable variable that can be used in query steps, source paths, or filter conditions.

Question 5

What does 'Remove Duplicates' do in Power Query when applied to a column?

Accepted Answer

Keeps only the first occurrence of each unique value in the selected column, removing subsequent duplicates

Answer

Remove Duplicates on a column retains the first occurrence of each unique value and deletes all subsequent duplicate rows.

Power BI 778 Practice Test