Which command should you use?

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

View Answer

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