What should you do?

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 m 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?
A. Append the Customer and Address tables.
B. Transpose the Customer and Address tables.
C. Group the Customer and Address tables by the Address ID column.
D. Merge the Customer and Address tables.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.