Exam 70-779 topic 1 question 53 discussion

Actual exam question from Microsoft's 70-779

Question #: 53
Topic #: 1

You have a query that retrieves the following data.

You need to configure the query to ensure that the data appears as shown in the following table.

What should you do?

A. From the Transform tab, use the sum function on the Vendor_ID column
B. Group by Vendor_ID and add a SUM aggregation
C. Unpivot the table on the Vendor_ID column
D. Pivot the table on the Vendor_ID column

Show Suggested Answer

Suggested Answer: B 🗳️
Reference:
https://www.powerquery.training/grouping-or-summarizing-data/

by noname12345 at March 1, 2020, 1:12 a.m.

Comments

Submit Cancel

JideID

5 years ago

Just to add more clarification. "Group By Vendor_ID and Sum Quantity " is how it should be and the closest is option C

upvoted 2 times

JideID

5 years ago

I meant "B"

upvoted 9 times

Agustin

4 years, 11 months ago

I tested it. You ae right!

upvoted 2 times

...

noname12345

5 years, 3 months ago

Why do you have to do all this. Doesn't excel sum by default?

upvoted 1 times

Glt

5 years, 2 months ago

It does sum by default in PivotTable, but here the question ask you to modify the query, so you need this step to obtain such table in Power Query.

upvoted 3 times

...