Exam 70-779 topic 1 question 25 discussion

Actual exam question from Microsoft's 70-779

Question #: 25
Topic #: 1

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?

A. Append Queries
B. Combine Binaries
C. Transpose
D. Merge Queries

Show Suggested Answer

Suggested Answer: D 🗳️
References:
https://support.office.com/en-us/article/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9

by Samewiss at Oct. 22, 2019, 9:09 a.m.

Comments

Submit Cancel

Samewiss

Highly Voted 5 years, 8 months ago

I am pretty sure that its A. Its clearly stated that the tables have the same columns, clearly an indicator that you can append. result would be a list of contact details for consultants and employees

upvoted 39 times

...

mohroshdy

Highly Voted 5 years, 7 months ago

"A. Append Queries" is the correct answer, to combine all the data from two queries that have the same structure, you have to use Append command.

upvoted 12 times

...

iaaqq

Most Recent 4 years, 5 months ago

A. Append Queries

upvoted 1 times

...

WarpCore

4 years, 8 months ago

The answer is A. Read this link. https://radacad.com/append-vs-merge-in-power-bi-and-power-query

upvoted 1 times

...

lyniguez

4 years, 9 months ago

WRONG, should be A

upvoted 1 times

...

engrabdul

5 years ago

Try and understand the question... Consultant and Employees? The combination of the two tables will give you flatten table. D is the correct answer

upvoted 2 times

r8d1

4 years, 11 months ago

i think that is exactly why you dont want to merge (i.e. a join). You may end up omitting rows of data with a merge. Safer to append.

upvoted 1 times

...

Debjit

4 years, 10 months ago

If you try to merge then on what keys? Obviously you cannot use consultant id and employee id as none will match. You can only do full outer join and so append is the best answer.

upvoted 6 times

...

Eric777

5 years ago

One more time, the stated answer and the reference link are at odds. The instruction is to combine two tables "into a single table." The reference link to Merge states that a primary table is created with an additional column, "containing a navigation link to a related table." So, two tables, not one. Did I miss something?

upvoted 1 times

...