Valid 70-779 Dumps shared by ExamDiscuss.com for Helping Passing 70-779 Exam! ExamDiscuss.com now offer the newest 70-779 exam dumps, the ExamDiscuss.com 70-779 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-779 dumps with Test Engine here:
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?
Correct Answer: D
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
