Which command should you use?

Posted by: Pdfprep Category: 70-779 Tags: , ,

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

Leave a Reply

Your email address will not be published.