PL-300 Question 123

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose C1

  * Answer: C. Unpivot columns - Exactly what we need. It takes the year columns (2020, 2021) and turns them into row values under a new Year column, with corresponding Sales values. * Why not the others: A. Merge columns - Combines multiple columns into one. Not what we need. B. Transpose - Flips rows ↔ columns. That would make months into columns, not helpful here. D. Pivot column - Does the opposite: turns row values into columns. We already have that problem.

• Chose C1

  unpivoting 2020 and 2021 columns wouls result in two columns "attribute" (to be renamed as "Year") and "Measure" (to be renamed as "Sales")

• Chose C1

  We need to unpivot columns and rename them