Exam PL-300 topic 3 question 79 discussion

Actual exam question from Microsoft's PL-300

Question #: 79
Topic #: 3

You have the CSV file shown in the following table.

You use Power Query Editor to preview the data in the file.

You need to transform the data to meet the following requirements:

• The first column must contain the month.
• The second column must contain the year.
• The third column must contain the order amount for the month and year.

Which transformation should you use first?

A. remove
B. unpivot
C. transpose
D. pivot

Show Suggested Answer

Suggested Answer: B 🗳️

by INDEAVR at Feb. 29, 2024, 9:03 a.m.

Comments

Submit Cancel

INDEAVR

Highly Voted 1 year, 5 months ago

Selected Answer: B

B. unpivot

upvoted 11 times

...

jaume

Most Recent 8 months, 3 weeks ago

Selected Answer: B

Whatever we could remove (option A) would result in a loss of information Transposing the table (Option C) would result in a 4x3 table with columns "Month", "January", "February" and "March" We shoud unpivot 2nd and 3rd columns

upvoted 1 times

...

1 year, 5 months ago

Selected Answer: B

B is correct

upvoted 1 times

...