Exam 70-779 topic 1 question 29 discussion

Actual exam question from Microsoft's 70-779

Question #: 29
Topic #: 1

HOTSPOT -
You have a workbook query that uses an Excel data source. The data source contains the following table.

You need the data to appear as shown in the following table.

How should you transform the data from Query Editor? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

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

by GST0101 at Oct. 8, 2019, 6:41 p.m.

Comments

Submit Cancel

Aurelkb

Highly Voted 5 years, 7 months ago

Correct answer is Columns : TestASCore, TestBSCore and TestCSCore Command : Unpivot Column If you select User and UserID in Columns, you need to have Unpivot Other Columns in Command

upvoted 38 times

SN22

5 years, 4 months ago

I agree

upvoted 5 times

...

mohroshdy

Highly Voted 5 years, 6 months ago

The correct answer is 1- "TestAScore, TestBStore, and TestCScore" 2- "Unpaivot Columns"

upvoted 25 times

...

k9999

Most Recent 4 years, 8 months ago

you can also select User and UserID->Unpivot other columns But all unpivot related questions are showing the same answer like this one. I guess the question get the panel selection and the M code wrongly. Because in M code, you will only find the columns names "User" and "UserID". But in panel, you need to select "TestASCore", "TestBSCore" and "TestCSCore".

upvoted 1 times

...

ArpanT

4 years, 8 months ago

For 1: "TestAScore, TestBStore, and TestCScore" For 2: "Unpivot columns"

upvoted 1 times

...

Outsider

5 years ago

Wrong. it is just select last three columns and then unpivot it.

upvoted 2 times

...

Mar_tin

5 years, 2 months ago

Very confusing! The given solution does not deliver the expected results. Chosing columns: TestAScore, TestBScore & TestCScore Chose Unpivot columns = expected results

upvoted 1 times

...

GST0101

5 years, 8 months ago

The first answer is wrong. The linked article states: "Unpivot Columns creates an Attribute column for EACH SELECTED COLUMN heading and a Value column for each selected column cell value." We are trying to turn the TestScore columns into our attribute column which means we need to select those and then click on unpivot columns.

upvoted 21 times

...