Question 222 of 388
Single answerYou 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 IDAddress contains the following columns:- Address ID- Address Line 1- Address Line 2- City- State/Region- Country- Postal CodeEach 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?
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.
✓
Correct Answer: D
Merge the Customer and Address tables.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.