Microsoft Exam 70-779 Topic 5 Question 4 Discussion

Actual exam question for Microsoft's 70-779 exam

Question #: 4
Topic #: 5

You have a workbook query that loads the following table

You pivot the table on the Key column by using Value as the values column, and you receive the results shown in the following table.

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

What should you do?

AChange the aggregate value function of the pivot.

BSelect the ID column, and then click Unpivot Columns

CChange the Data Type of the Value column.

DDelete the Picoted Column step. Select the Key column, and the click UnpivotColumns.

Show Suggested Answer

Suggested Answer: B

by Amber at May 03, 2022, 04:58 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!