PL-300 · Question #102
PL-300 Question #102: Real Exam Question with Answer & Explanation
Sign in or unlock PL-300 to reveal the answer and full explanation for question #102. The question stem and answer options stay visible for context.
Question
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 The Customer ID and Address ID columns represent unique rows. 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?
Options
- AMerge the Customer and Address tables.
- BTranspose the Customer and Address tables.
- CGroup the Customer and Address tables by the Address ID column.
- DAppend the Customer and Address tables.
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.