Question 296 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 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?
✓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.
✓
Correct Answer: A
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.