Exam PL-300 topic 2 question 75 discussion

Actual exam question from Microsoft's PL-300

Question #: 75
Topic #: 2

You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit.

You need to shape the query to display the following three columns:

• Month
• Sales
• Year

What should you select in Power Query Editor?

A. Merge columns
B. Transpose
C. Unpivot columns
D. Pivot column

Show Suggested Answer

Suggested Answer: C 🗳️

by pverde at Aug. 5, 2023, 1:29 p.m.

Comments

Submit Cancel

LeeLee_105

Highly Voted 1 year, 12 months ago

Selected Answer: C

It's the classic definition of unpivot

upvoted 31 times

...

Starvosxant

Highly Voted 1 year, 8 months ago

Upvote this comment so all your exam questions will be like this 🙌🙏

upvoted 25 times

...

jaume

Most Recent 8 months, 4 weeks ago

Selected Answer: C

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

upvoted 1 times

...

rcaliandro

12 months ago

Selected Answer: C

We need to unpivot columns and rename them

upvoted 1 times

...

AZFabio

1 year, 4 months ago

Selected Answer: C

Sales numbers are pivoted in 2 "year" columns. Just need to unpivot these columns, then rename atribute and value columns to something like "Year" and "Total Sales".

upvoted 2 times

...

marcolapo92

1 year, 10 months ago

Selected Answer: C

C Correct

upvoted 4 times

...

Igetmyrole

1 year, 11 months ago

C is correct. To shape the query to display the required three columns (month, sales,year), you should select the "Unpivot columns" option in Power Query Editor. This will transfer the data from its current columnar structure (where each year is a separate column) into a tabular format with separate rows for each combination of Month, Sales, and Year.

upvoted 5 times

...