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?
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.