Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 34 discussion

Actual exam question from Microsoft's 70-779

Question #: 34
Topic #: 1

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?

A. Change the Aggregate Value Function of the pivot
B. Change the Data Type of the Value column
C. Select the ID column, and then click Unpivot Columns
D. Delete the Pivoted Column step. Select the Key column, and then click Unpivot Columns

Show Suggested Answer

Suggested Answer: C 🗳️
References:
https://support.office.com/en-us/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

by GST0101 at Oct. 9, 2019, 4:34 a.m.

Comments

Submit Cancel

GST0101

Highly Voted 5 years, 8 months ago

The answer is just plain wrong. The answer is A. You would pivot the column and set the Aggregate Value Function to none.

upvoted 30 times

ammu

5 years, 7 months ago

Isn't it the Option D?

upvoted 1 times

fabioco

4 years, 11 months ago

No D is for UnPivoting

upvoted 1 times

...

imran

Highly Voted 5 years, 8 months ago

A is the correct one 100%

upvoted 21 times

...

mssql

Most Recent 4 years, 8 months ago

tested, is A, you select KEY and VALUE, with pivot, value column as VALUE and on Advanced options you change the aggregate function to Don't Aggregate

upvoted 2 times

...

CDL

4 years, 8 months ago

tested, A is right. go with imran's link: https://support.office.com/en-us/article/pivot-columns-abc9c8da-3be9-44c4-886e-0be331ab387a?ui=en-US&rs=en-AU&ad=AU steps: 1. in Query Editor, tab-->"transform" to "Pivot column" --> "Key" 2. in the pop up window, click "advanced option", and then select "Don't Aggregate" 3. load to table. (u will see the exact result)

upvoted 2 times

hfgirona

4 years, 7 months ago

ok! 1. in Query Editor, tab-->"transform" to "Pivot column" --> "Key" 2. in the pop up window, Value as value column;click "advanced option", and then select "Don't Aggregate" 3. load to table. (u will see the exact result)

upvoted 1 times

...

Sober

4 years, 8 months ago

I go with A

upvoted 1 times

...

Outsider

4 years, 12 months ago

Correct Answer is A A. Change the Aggregate Value Function of the pivot. Tested

upvoted 2 times

...

Chikhalsouk

5 years, 1 month ago

A is the right answer. Tested.

upvoted 2 times

...

ThomasKwakman

5 years, 2 months ago

The Answer is A. Just to be sure I tested the other solutions: it's definitely A.

upvoted 1 times

...

SN22

5 years, 4 months ago

Correct answer is A - I've tested it

upvoted 4 times

...

mohroshdy

5 years, 6 months ago

"A. Change the Aggregate Value Function of the pivot" is the correct answer. Just open pivoted column step gear sign then Advanced Options then change Aggregate Value Function to "Don't aggregate". TESTED 100% Correct

upvoted 10 times

...

imran

5 years, 8 months ago

https://support.office.com/en-us/article/pivot-columns-abc9c8da-3be9-44c4-886e-0be331ab387a?ui=en-US&rs=en-AU&ad=AU

upvoted 4 times

m_anies85

5 years, 2 months ago

which one is true ?

upvoted 1 times

...