Microsoft
70-779 · Question #111
70-779 Question #111: Real Exam Question with Answer & Explanation
Sign in or unlock 70-779 to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
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
Unlock 70-779 to see the answer
You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.