70-779 · Question #65
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 D. Append Queries. 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
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
- BMerge Queries
- CCombine Binaries
- DAppend Queries
How the community answered
(26 responses)- A12% (3)
- B4% (1)
- C4% (1)
- D81% (21)
Explanation
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
Topics
Community Discussion
No community discussion yet for this question.