Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 2 question 1 discussion

Actual exam question from Microsoft's 70-779

Question #: 1
Topic #: 2

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 exam_taker5 at July 15, 2019, 7:12 p.m.

Comments

Submit Cancel

exam_taker5

Highly Voted 5 years, 11 months ago

I believe that the correct answer is A. We want to append because the tables have the exact same columns.

upvoted 30 times

...

Samewiss

Highly Voted 5 years, 7 months ago

tables have exactly the same colums, so i would also go with A. Smae question as on page 4 or so

upvoted 8 times

...

CDL

Most Recent 4 years, 8 months ago

A is correct, [Name]+[Phone], same structure, Append them, and select both columns and "remove duplicate" . If Merge, what's the point? use same name pull out another phone#? Obviously the purpose here is from 2 different external records to combine into one complete record.

upvoted 1 times

...

Tobi999

4 years, 9 months ago

I Guess D is right, because you have consultants and employees. That is not the same. With append you would mix them together.

upvoted 1 times

...

Livy

5 years, 3 months ago

merge is the answer

upvoted 1 times

JideID

5 years, 1 month ago

When it come to Merge enphasy wouldn't be on "same column", both tables could have different columns but for you to append, the tables must have "same number of column". So, Append is the answer.

upvoted 3 times

...

Debjit

4 years, 9 months ago

if u merge then what columns will you use to join? contarctor id and employee id wudnt match. So Append is the answer

upvoted 1 times

...

mihenova

5 years, 4 months ago

The correct option is A, both tables have the same structure.

upvoted 2 times

...

cs3122

5 years, 4 months ago

Append when you want to combine queries with the same columns, and merge when you want to bring two different column structures together. In this case, only Append Queries, A, is the correct answer.

upvoted 3 times

...

Annelize

5 years, 6 months ago

I agree with A https://radacad.com/append-vs-merge-in-power-bi-and-power-query

upvoted 6 times

...

mohroshdy

5 years, 6 months ago

A is correct

upvoted 5 times

...