New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 70-779 Topic 11 Question 2 Discussion

Actual exam question for Microsoft's 70-779 exam
Question #: 2
Topic #: 11
[All 70-779 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

Append is similar to UNION ALL in T-SQL.

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


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel