Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
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]
Topic #: 11
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?
Suggested Answer:
B
Append is similar to UNION ALL in T-SQL.
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Currently there are no comments in this discussion, be the first to comment!