Microsoft Power BI Data Analyst — Question 30

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

Answer options

• A. Merge queries
• B. Combine files
• C. Append queries

Correct answer: A

Explanation

The correct answer is A, Merge queries, because this action allows you to join the two tables based on the related column, Order ID, effectively combining their unique columns. The other options, Combine files and Append queries, do not serve the purpose of merging tables based on a common key; Combine files is typically used for files with similar structures, while Append queries is for stacking tables vertically.