PL-300 · Question #296
PL-300 Question #296: Real Exam Question with Answer & Explanation
Sign in or unlock PL-300 to reveal the answer and full explanation for question #296. 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 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?
Options
- AMerge the Customer and Address tables.
- BGroup the Customer and Address tables by the Address ID column.
- CTranspose the Customer and Address tables.
- 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.