ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 1 question 8 discussion

Actual exam question from Microsoft's DA-100
Question #: 8
Topic #: 1
[All DA-100 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
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 Hide Answer
Suggested Answer: A 🗳️
by kiranramasamy at Oct. 8, 2020, 5:21 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
kiranramasamy
Highly Voted 4 years, 6 months ago
Answer is A
upvoted 93 times
...
JessieVuong
Highly Voted 3 years, 10 months 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
Davico93
2 years, 10 months ago
Append is for more rows, right? not columns
upvoted 1 times
TuM29
2 years, 9 months ago
Yes, when you append you add rows of one table to the other
upvoted 1 times
...
...
...
MichalP78
Most Recent 2 years, 8 months ago
Selected Answer: A
I agree with A
upvoted 1 times
...
claudeaboki
2 years, 10 months ago
A is correct
upvoted 2 times
...
Sharaja
2 years, 10 months ago
A is correct. Was in exam.
upvoted 1 times
...
Mona00
2 years, 11 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
vineyvinni
3 years ago
Selected Answer: A
answer A is correct
upvoted 1 times
...
khaipn2712
3 years, 1 month ago
Selected Answer: A
IF have one or more columns and need to add other table, You can merge it together
upvoted 1 times
...
mnnopen
3 years, 1 month ago
Selected Answer: A
Merge the columns and append the lines
upvoted 1 times
...
AshayS
3 years, 1 month ago
In Exam Dt 5th March 2022
upvoted 1 times
...
Ashley090521
3 years, 2 months ago
on exam 3/1/2022
upvoted 1 times
...
Sudhansu21
3 years, 2 months ago
On Exam Feb, 2022
upvoted 1 times
...
Anju5050
3 years, 2 months ago
Id contains unique value so you can use merge. In this case, both The Customer ID and Address ID columns represent unique rows. If there is case multiple same ids then you can use Group By accordingly. For per customer and per region or state
upvoted 1 times
...
hoss29
3 years, 2 months ago
A is the answer
upvoted 1 times
...
washy
3 years, 2 months ago
A is correct
upvoted 1 times
...
battenarajesh
3 years, 3 months ago
Answer is A
upvoted 1 times
...
Shan
3 years, 4 months ago
on exam 30/12/21
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago