Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 3 Question 84 Discussion

You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns:* Customer ID* Customer Name* Phone* Email Address* Address IDAddress contains the following columns:* Address ID* Address Line 1* Address Line 2* City* State/Region* Country* Postal CodeEach Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?
D) Merge the Customer and Address tables.
A) Append the Customer and Address tables.
B) Transpose the Customer and Address tables.
C) Group the Customer and Address tables by the Address ID column.

Microsoft PL-300 Exam - Topic 3 Question 84 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 84
Topic #: 3
[All PL-300 Questions]

You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns:

* Customer ID

* Customer Name

* Phone

* Email Address

* Address ID

Address contains the following columns:

* Address ID

* Address Line 1

* Address Line 2

* City

* State/Region

* Country

* Postal Code

Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Gail at Jun 21, 2026, 02:13 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Wilbert
23 days ago
I feel like C could work too, but it won't give us the full customer details.
upvoted 0 times
...
Shonda
29 days ago
Agreed! D allows us to get all customer info with their addresses.
upvoted 0 times
...
Justine
1 month ago
I think D is the best choice. Merging makes sense for combining data.
upvoted 0 times
...
Jesusita
1 month ago
Merging makes sense, but what if there are duplicate addresses?
upvoted 0 times
...
Kanisha
1 month ago
Grouping won't give you the right result, so that's a no-go.
upvoted 0 times
...
Essie
2 months ago
Wait, can you really merge them like that? Sounds too easy.
upvoted 0 times
...
Refugia
2 months ago
Totally agree, merging is the best option here.
upvoted 0 times
...
Johnna
2 months ago
D) Merge the Customer and Address tables. That's the way to go!
upvoted 0 times
...
Marvel
2 months ago
I’m a bit confused about whether to group or merge. I think merging would give us the right columns, but I need to double-check.
upvoted 0 times
...
Sylvia
2 months ago
I feel like appending might not work since we need to match rows based on IDs. Merging seems more appropriate, but I could be wrong.
upvoted 0 times
...
Lezlie
3 months ago
I remember practicing a similar question where we had to join tables. Merging sounds familiar for this scenario.
upvoted 0 times
...
Leontine
3 months ago
I think we need to combine the tables somehow, but I'm not sure if merging is the right approach.
upvoted 0 times
...

Save Cancel