Question 1

In Power Query, which transformation can be used to merge columns from two different tables based on a common field?

Accepted Answer

Merge Queries

Answer

Split Column

Answer

Group By

Answer

Append Queries

Question 2

What is the main difference between 'Duplicate' and 'Reference' in Power Query?

Accepted Answer

Duplicate creates an independent copy, Reference creates a linked query

Answer

Duplicate merges two queries, Reference appends two queries

Answer

Duplicate adds a new column, Reference deletes a column

Answer

Duplicate creates a linked query, Reference creates an independent copy

Question 3

Which function in Power Query is used to remove extra spaces from the beginning and end of text strings?

Accepted Answer

Trim

Answer

Clean

Answer

Substitute

Answer

Replace

Question 4

In a real-life scenario, how can you use Power Query to prepare sales data from multiple regions for analysis?

Accepted Answer

Use Append Queries to combine data from multiple tables

Answer

Use Split Column to separate data from different regions

Answer

Use Group By to aggregate data by regions

Answer

Use Merge Queries to combine data from multiple tables

Question 5

When transforming data in Power Query, what is the purpose of the 'Group By' transformation?

Accepted Answer

To aggregate data based on a specified column or columns

Answer

To duplicate data from a specified column

Answer

To merge multiple tables

Answer

To split data into multiple columns

Question 6

How can Power Query help in handling null values in a dataset?

Accepted Answer

Replace null values with a specified value

Answer

Split columns with null values

Answer

Delete rows containing null values

Answer

Duplicate rows containing null values

Question 7

If you want to remove duplicate rows from a dataset in Power Query, which transformation would you use?

Accepted Answer

Remove Duplicates

Answer

Filter Rows

Answer

Keep Duplicates

Answer

Remove Errors

Question 8

In a real-world scenario, how can you use Power Query to automate the monthly data refresh for a report?

Accepted Answer

Schedule data refresh in Power BI Service

Answer

Split the dataset into monthly chunks

Answer

Manually refresh the data every month

Answer

Use Group By to aggregate monthly data

Question 9

What is the advantage of using 'Conditional Column' in Power Query?

Accepted Answer

It allows creating new columns based on conditional logic

Answer

It merges columns based on conditions

Answer

It removes columns based on conditions

Answer

It duplicates columns based on conditions

Question 10

How does Power Query enhance data preparation for machine learning models?

Accepted Answer

It allows cleaning, transforming, and shaping data efficiently before analysis

Answer

It visualizes data for machine learning models

Answer

It directly builds machine learning models

Answer

It replaces the need for feature engineering

Related quizzes

Related quizzes