Question 102 of 388
Single answerYou import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:Customer IDCustomer NamePhoneEmail AddressAddress IDAddress contains the following columns:Address IDAddress Line 1Address Line 2 CityState/RegionCountryPostal CodeThe Customer ID and Address ID columns represent unique rows.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.
BTranspose the Customer and Address tables.
CGroup the Customer and Address tables by the Address ID column.
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.