PL-300 Exam QuestionsBrowse all questions from this exam

PL-300 Exam - Question 29


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?

Show Answer
Correct Answer: A

To combine two tables in Power Query Editor into a single query that contains the unique columns of each table, you should select 'Merge queries'. Merging queries is akin to performing a SQL join, where you combine rows from both tables based on a related column, in this case, the Order ID. This allows you to include columns from both tables into a single query. 'Append queries' would be used if you wanted to add rows from one table to another, essentially stacking them, while 'Combine files' is not applicable in this context as it pertains to combining multiple files, not tables within a database.

Discussion

17 comments
Sign in to comment
DataEngDPOption: A
Feb 29, 2024

There are two primary ways of combining queries: merging and appending. For one or more columns that you’d like to add to another query, you merge the queries. For one or more rows of data that you’d like to add to an existing query, you append the query. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

GiudittaOption: A
Mar 15, 2024

this was on exam on 14/03/2024 i scored 948 my answer was A Merge

shahrzadkhb
Apr 19, 2024

Can you please tell me how did you prepare for the exam? Did you read all the questions from ExamTopics? If yes, did it help you? I also plan to take the exam within two weeks and I am not sure if this dump file would help or I also need to prepare from other source as well.

phoenixxWR
Apr 23, 2024

I have my exam in 3 weeks. I have gone through PBI training videos on MS.com and now reading through these. Hope this would be enough.

gradmesOption: A
Oct 9, 2023

A. Merge queries

AZFabioOption: A
Mar 11, 2024

Merge = SQL join

sankeytmOption: A
Oct 7, 2023

Option A is correct

riwahofOption: A
Oct 9, 2023

Seriously, who even proposes C?

faes
Oct 16, 2023

People who´re learning

IrynaVilnerOption: A
Oct 17, 2023

Answer A is correct

TrustMyAnswersOption: A
Nov 6, 2023

Answer A is correct.

08b2ddd
Dec 29, 2023

I hope I get this one on my exam...

Muthukumar_SubbaiyanOption: A
Mar 23, 2024

As per my understanding both the tables are related to orders, one is header data i.e is dimension, another one is Fact, so column's will be different in both the tables, in such case we need to user Merge

Mati_123
Oct 5, 2023

option D is correct

SwapnJOption: A
Oct 7, 2023

Option A

jl234Option: C
Oct 7, 2023

To combine two tables in Power Query Editor into a single query that contains the unique columns of each table, we should select option C, which is "Append queries."

MateoRook
Oct 8, 2023

Correct answer is A. Merge combines columns. Append combines rows. The question is about related tables.

TDwayne
Dec 9, 2023

You can also think of Append like a Union in SQL, it just puts datasets beneath eachother but does not merge any unique values together. Sorry if the explanation is unclear I am still learning myself as well.

Roh1410Option: A
Jan 25, 2024

Merge Queries

Tinashe16Option: A
May 27, 2024

Merge is correct, because of the distinct individual columns which should remain

DsbuffOption: A
Dec 19, 2023

A is correct, hands down.

Kiran37Option: A
Jul 21, 2024

Merge is correct