Exam DA-100 topic 1 question 8 discussion

Actual exam question from Microsoft's DA-100

Question #: 8
Topic #: 1

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?

A. Merge 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. Append the Customer and Address tables.

Show Suggested Answer

Suggested Answer: A 🗳️

by kiranramasamy at Oct. 8, 2020, 5:21 p.m.

Comments

Submit Cancel

kiranramasamy

Highly Voted 4 years, 10 months ago

Answer is A

upvoted 93 times

...

JessieVuong

Highly Voted 4 years, 1 month ago

A is the correct answer A. Merge function is to expand more columns horizontally. B. Transpose function is to convert row to column, and column to become row. C. Group by Address ID will help to count how many xxx (xxx is attribute that you choose) for one address ID D Append function is to add more rows vertically.

upvoted 33 times