Question 1

What is the purpose of Power Query Editor?

Accepted Answer

To shape and transform data before it is used in Power BI reports.

Answer

To connect to data sources.

Answer

To create charts and visualizations.

Answer

To write and execute queries.

Question 2

What are the two most common ways to combine queries in Power BI?

Accepted Answer

Merging and appending.

Answer

Reshaping and transforming.

Answer

Combining and shaping.

Answer

Merging and filtering.

Question 3

How do you rename a column in Power Query Editor?

Accepted Answer

There are three ways: select the column and then either select rename from the Transform tab on the ribbon, right-click and select rename, or select the column header and type a new name.

Answer

You must rename the column in the original data source.

Answer

You can only rename a column by right-clicking and selecting rename.

Answer

You cannot rename columns in Power Query Editor.

Question 4

What is the difference between merging and appending queries in Power BI?

Accepted Answer

Merging combines columns from two tables based on a matching column, while appending adds rows from one table to the end of another table.

Answer

Merging and appending both achieve the same outcome, which is to combine data from two tables.

Answer

There is no difference between merging and appending queries in Power BI.

Answer

Merging removes duplicate rows from the tables being combined, while appending keeps all rows.

Question 5

How can you sort a table in Power Query Editor?

Accepted Answer

Select the column you want to sort by, then select the sort ascending or sort descending option from the Home tab on the ribbon.

Answer

You must sort the data in the original data source.

Answer

You cannot sort tables in Power Query Editor.

Answer

Sorting can only be done after the data is imported into Power BI Desktop.

Question 6

What is the purpose of the "promoted headers" step in Power Query Editor?

Accepted Answer

To set the top row of a table as the column headers.

Answer

To remove the top row of a table.

Answer

To change the data type of the columns in a table.

Answer

To rename the columns in a table.

Question 7

What does the "changed type" step in Power Query Editor do?

Accepted Answer

It automatically converts columns to their inferred data types, such as changing text columns to numbers.

Answer

It converts all columns to text data type.

Answer

It allows you to manually specify the data type for each column.

Answer

It does not change the data types of any columns.

Question 8

How can you create a custom column in Power Query Editor?

Accepted Answer

Select the "Add Column" option from the Home tab on the ribbon, then enter a formula to define the new column.

Answer

You must create custom columns in the original data source.

Answer

Custom columns cannot be created in Power Query Editor.

Answer

Custom columns can only be created after the data is imported into Power BI Desktop.

Question 9

What happens when you remove a step in the Applied Steps list in Power Query Editor?

Accepted Answer

The changes made by that step are reversed, and the data is returned to the state it was in before that step was applied.

Answer

The data source is permanently modified.

Answer

You cannot remove steps from the Applied Steps list.

Answer

All subsequent steps in the Applied Steps list are also removed.

Question 10

How do you insert a new step in the Applied Steps list in Power Query Editor?

Accepted Answer

Right-click on an existing step and select "Insert Step Before" or "Insert Step After".

Answer

You cannot insert new steps into the Applied Steps list.

Answer

New steps are always added to the end of the Applied Steps list.

Answer

You must create a new query to add any new steps.

Related quizzes

Related quizzes