Exam DP-600 topic 1 question 42 discussion

Actual exam question from Microsoft's DP-600

Question #: 42
Topic #: 1

You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1 contains a query that returns the data shown in the following exhibit.

You need to transform the data columns into attribute-value pairs, where columns become rows.
You select the VendorID column.
Which transformation should you select from the context menu of the VendorID column?

A. Group by
B. Unpivot columns
C. Unpivot other columns
D. Split column
E. Remove other columns

Show Suggested Answer

Suggested Answer: C 🗳️

by Momoanwar at Feb. 18, 2024, 12:57 a.m.

Comments

Submit Cancel

Momoanwar

Highly Voted 1 year, 6 months ago

Selected Answer: C

Correct

upvoted 11 times

...

Rakesh16

Most Recent 9 months, 1 week ago

Selected Answer: C

Unpivot other columns

upvoted 1 times

...

stilferx

1 year, 3 months ago

Selected Answer: C

IMHO, "C", Because of: Unpivot other columns This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted. description is here: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098#:~:text=Select%20the%20columns%20you%20do,Transform%20%3E%20Unpivot%20Only%20Selected%20Columns.

upvoted 3 times

...

Nefirs

1 year, 4 months ago

Selected Answer: C

clearly C

upvoted 1 times

...

XiltroX

1 year, 5 months ago

C is the correct answer

upvoted 3 times

...