You have an Excel workbook that has the following two workbook queries:
A query named Consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database
A query named Employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database
Both tables have the same columns.
You need to combine all the data from Consultants and Employees into one table.
Which command should you use?
A . Transpose
B . Merge Queries
C . Combine Binaries
D . Append Queries
Answer: D
Explanation:
Append is similar to UNION ALL in T-SQL.
Append Queries will NOT remove duplicates. You have to use Group By or Remove Duplicate Rows to get rid of duplicates.
Merge is similar to JOIN in T-SQL
http://radacad.com/append-vs-merge-in-power-bi-and-power-query