Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft PL-300 Exam - Topic 3 Question 84 Discussion

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 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 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?
D) Merge the Customer and Address tables.
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.

Microsoft PL-300 Exam - Topic 3 Question 84 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 84
Topic #: 3
[All PL-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

0/2000 characters

Currently there are no comments in this discussion, be the first to comment!


Save Cancel