exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 4 discussion

Actual exam question from Microsoft's PL-300
Question #: 4
Topic #: 1
[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 in the Customer table. Each Address ID represents a unique address in 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?

  • A. Merge the Customer and Address tables.
  • B. Group the Customer and Address tables by the Address ID column.
  • C. Transpose the Customer and Address tables.
  • D. Append the Customer and Address tables.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
mannerism
Highly Voted 2 years, 6 months ago
Remember Merge is JOIN, APPEND is UNION
upvoted 63 times
...
MirianeAn
Most Recent 4 weeks, 1 day ago
Selected Answer: A
Fusionner, car les tables ont des colonnes différentes et une colonne IDclient commune aux deux tables
upvoted 1 times
...
Kbo05
1 month, 1 week ago
Selected Answer: A
JOIN 2 cables with the common field
upvoted 1 times
...
Iron_Jade
1 month, 4 weeks ago
Selected Answer: A
Merge will add columns while Append will add rows
upvoted 1 times
...
Hosna2023
2 months ago
Selected Answer: A
By merging the two tables on the Address ID, you combine each customer's data with the corresponding address details, resulting in one row per customer that includes City, State/Region, and Country.
upvoted 2 times
...
raavilam
2 months, 4 weeks ago
Selected Answer: A
Merge(join) using the common filed Address ID
upvoted 4 times
...
lucasnatanael93
2 months, 4 weeks ago
Selected Answer: A
E a letra A, pois ira pega ID Cliente com ID de endereço ira fazer 1 para 1
upvoted 1 times
...
Hoooota
3 months, 3 weeks ago
Selected Answer: A
Merge because its kind of join
upvoted 2 times
...
ThandaPanda11
5 months ago
Selected Answer: A
Merging two tables will help us in getting the required columns from other table
upvoted 3 times
...
DexTorao
5 months, 1 week ago
A- Merge
upvoted 1 times
...
mv79
5 months, 2 weeks ago
You can't append them because they aren't the same columns, so you can merge them using the address_id. I checked merge.
upvoted 4 times
...
ChopChop007
7 months, 1 week ago
Merge is correct.
upvoted 1 times
...
rcaliandro
8 months, 3 weeks ago
Selected Answer: A
The right answer is A. Merge the Customer and Address tables. Because we need to merge (join) the customer table with the address table via the addressId
upvoted 3 times
...
Kiran37
9 months, 1 week ago
Selected Answer: A
Merge is correct it combine two table & act as join
upvoted 1 times
...
Nishi_06
9 months, 3 weeks ago
Merge the Customer and Address tables.
upvoted 1 times
...
Grey_Head
11 months, 4 weeks ago
Selected Answer: A
Merge will add the additional columns needed.
upvoted 1 times
...
Roh1410
1 year, 3 months ago
Selected Answer: A
Merge the tables
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago