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?
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.
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
this was on exam on 14/03/2024 i scored 948 my answer was A Merge
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.
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.
Merge = SQL join
A. Merge queries
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
I hope I get this one on my exam...
Answer A is correct.
Answer A is correct
Seriously, who even proposes C?
People who´re learning
Option A is correct
Merge is correct, because of the distinct individual columns which should remain
Merge Queries
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."
Correct answer is A. Merge combines columns. Append combines rows. The question is about related tables.
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.
Option A
option D is correct
Merge is correct
A is correct, hands down.