Microsoft
70-779 · Question #111
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?
The correct answer is B. Group by Vendor_ID and add a SUM aggregation. See the full explanation below for the reasoning.
Question
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?
Options
- AFrom the Transform tab, use the sum function on the Vendor_ID column
- BGroup by Vendor_ID and add a SUM aggregation
- CUnpivot the table on the Vendor_ID column
- DPivot the table on the Vendor_ID column
How the community answered
(38 responses)- A3% (1)
- B76% (29)
- C8% (3)
- D13% (5)
Community Discussion
No community discussion yet for this question.