DP-600 Question #34: Real Exam Question with Answer & Explanation

Question

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?

Options

• AGroup by
• BUnpivot columns
• CUnpivot other columns
• DSplit column
• ERemove other columns

Explanation

To transform data columns into attribute-value pairs while retaining the VendorID as an identifier, the 'Unpivot other columns' transformation in Power Query should be selected.

Common mistakes.

• A. 'Group by' is used to aggregate rows based on common values, not to restructure columns into rows for attribute-value pairs.

Concept tested. Power Query unpivot transformation

Reference. https://learn.microsoft.com/en-us/power-query/unpivot-columns

No community discussion yet for this question.