PdfPrep.com

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 . Append Queries
C . Merge Queries
D . Combine Binaries

Answer: B

Explanation:

Append is similar to UNION ALL in T-SQL.

http://radacad.com/append-vs-merge-in-power-bi-and-power-query

Exit mobile version