Microsoft
70-779 · Question #12
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…
The correct answer is B. Append Queries. Append is similar to UNION ALL in T-SQL.
Consume and transform data by using Microsoft Excel
Question
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?
Options
- ATranspose
- BAppend Queries
- CMerge Queries
- DCombine Binaries
How the community answered
(37 responses)- A8% (3)
- B78% (29)
- C11% (4)
- D3% (1)
Explanation
Append is similar to UNION ALL in T-SQL.
Topics
#Append Queries#Power Query#combining tables#workbook queries
Community Discussion
No community discussion yet for this question.