PL-300 · Question #222
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 co
Sign in or unlock PL-300 to reveal the answer and full explanation for question #222. 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
Each Customer ID represents a unique customer m 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?
Options
- AAppend the Customer and Address tables.
- BTranspose the Customer and Address tables.
- CGroup the Customer and Address tables by the Address ID column.
- DMerge 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.