ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 65 discussion

Actual exam question from Microsoft's 70-778
Question #: 65
Topic #: 1
[All 70-778 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
123
Highly Voted 4 years, 10 months 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, 5 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, 6 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
4 years, 9 months 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
4 years, 10 months ago
Append requires columns to be exactly similar Combine requires multiple files that have the same schema
upvoted 3 times
...
NRani
4 years, 11 months ago
Sorry, read the article it's clear now
upvoted 1 times
...
NRani
4 years, 11 months ago
What's the difference between merge and append?
upvoted 1 times
Agustin
4 years, 10 months ago
Append lets you append things, while merge allows you to merge them. It is very clear in the article.
upvoted 2 times
...
wudixh
4 years, 10 months ago
Append for combine rows, merge for combine columns
upvoted 5 times
...
frakcha
4 years, 9 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, 8 months ago
Yes. This is the right idea.
upvoted 1 times
...
...
cromastro
4 years, 8 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
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago