Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 29 discussion

Actual exam question from Microsoft's PL-300

Question #: 29
Topic #: 1

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

A. Merge queries
B. Combine files
C. Append queries

Show Suggested Answer

Suggested Answer: A 🗳️

by Mati_123 at Oct. 5, 2023, 9:46 p.m.

Comments

Submit Cancel

DataEngDP

Highly Voted 1 year, 5 months ago

There are two primary ways of combining queries: merging and appending. For one or more columns that you’d like to add to another query, you merge the queries. For one or more rows of data that you’d like to add to an existing query, you append the query. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

upvoted 19 times

...

Thejani

Most Recent 3 months ago

Selected Answer: A

A is correct , using Order ID column.

upvoted 1 times

...

ee0625a

6 months, 3 weeks ago

Selected Answer: A

Merging the two using the common OrderID Column is a better option

upvoted 2 times

...

faruk3d

11 months, 3 weeks ago

Selected Answer: A

A is correct

upvoted 1 times

...

rcaliandro

1 year ago

Selected Answer: A

Of course A, merging (join) queries

upvoted 1 times

...

Kiran37

1 year ago

Merge is correct

upvoted 1 times

...

Tinashe16

1 year, 2 months ago

Merge is correct, because of the distinct individual columns which should remain

upvoted 2 times

...

Muthukumar_Subbaiyan

1 year, 4 months ago

As per my understanding both the tables are related to orders, one is header data i.e is dimension, another one is Fact, so column's will be different in both the tables, in such case we need to user Merge

upvoted 4 times

...

AZFabio

1 year, 5 months ago

Selected Answer: A

Merge = SQL join

upvoted 4 times

...

Roh1410

1 year, 6 months ago

Merge Queries

upvoted 2 times

...

08b2ddd

1 year, 7 months ago

I hope I get this one on my exam...

upvoted 4 times

...

Dsbuff

1 year, 8 months ago

Selected Answer: A

A is correct, hands down.

upvoted 1 times

...

TrustMyAnswers

1 year, 9 months ago

Selected Answer: A

Answer A is correct.

upvoted 3 times

...

IrynaVilner

1 year, 10 months ago

Answer A is correct

upvoted 3 times

...

gradmes

1 year, 10 months ago

Selected Answer: A

A. Merge queries

upvoted 4 times

...

riwahof

1 year, 10 months ago

Selected Answer: A

Seriously, who even proposes C?

upvoted 3 times

faes

1 year, 10 months ago

People who´re learning

upvoted 5 times

...

jl234

1 year, 10 months ago

Selected Answer: C

To combine two tables in Power Query Editor into a single query that contains the unique columns of each table, we should select option C, which is "Append queries."

upvoted 2 times

MateoRook

1 year, 10 months ago

Correct answer is A. Merge combines columns. Append combines rows. The question is about related tables.

upvoted 4 times

...

TDwayne

1 year, 8 months ago

You can also think of Append like a Union in SQL, it just puts datasets beneath eachother but does not merge any unique values together. Sorry if the explanation is unclear I am still learning myself as well.

upvoted 3 times

...

Load full discussion...