PL-300 · Question #222
PL-300 Question #222: Real Exam Question with Answer & Explanation
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.