Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 65 discussion

Actual exam question from Microsoft's 70-778

Question #: 65
Topic #: 1

You have the following two queries in Power BI Desktop:
✑ A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
✑ A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle Server database
Both tables have the same columns.
You need to combine the data from SMB_Customers and Enterprise_Customers.
Which command should you use?

A. Combine Files
B. Merge Queries
C. Merge Columns
D. Append Queries

Show Suggested Answer

Suggested Answer: D 🗳️
References:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query

by NRani at June 7, 2020, 10:34 a.m.

Comments

Submit Cancel

123

Highly Voted 5 years, 1 month ago

In essence, "append" makes the table LONGER (same columns), while "merge" makes the table WIDER (adding new columns)

upvoted 5 times

...

Arewa

Most Recent 4 years, 8 months ago

Merge is union and append is like union all Union get rid of duplicates, union all everything inclusive.

upvoted 1 times

...

CDL

4 years, 9 months ago

Append is used for same structure table, combine vertically. Merge is used for kinda like Vlookup function(via common column), combine horizontally to pull out the other table's some column's info, also could think of the RELATED function in DAX.

upvoted 1 times

...

Ikay81

5 years ago

"Append" works like UNION in SQL (adding more rows) while "merge" on the other hand, works like JOIN in SQL (adding more columns). Vertical / Horizontal.

upvoted 2 times

...

DAX_learner

5 years, 1 month ago

Append requires columns to be exactly similar Combine requires multiple files that have the same schema

upvoted 3 times

...

NRani

5 years, 1 month ago

Sorry, read the article it's clear now

upvoted 1 times

...

NRani

5 years, 1 month ago

What's the difference between merge and append?

upvoted 1 times

Agustin

5 years, 1 month ago

Append lets you append things, while merge allows you to merge them. It is very clear in the article.

upvoted 2 times

...

wudixh

5 years, 1 month ago

Append for combine rows, merge for combine columns

upvoted 5 times

...

frakcha

4 years, 11 months ago

If I understand correctly an append is like union in SQL while merge is like a join

upvoted 4 times

cromastro

4 years, 11 months ago

Yes. This is the right idea.

upvoted 1 times

...

cromastro

4 years, 11 months ago

I'll give you a real answer. Merge is used when you need to add columns from one table to another. The table schemas do not need to be the same. Append is when you want to add records from one table to another. The table schemas need to be the same.

upvoted 6 times

...