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 The 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?
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.
