ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 34 discussion

Actual exam question from Microsoft's PL-300
Question #: 34
Topic #: 2
[All PL-300 Questions]

DRAG DROP -
You receive revenue data that must be included in Microsoft Power BI reports.
You preview the data from a Microsoft Excel source in Power Query as shown in the following exhibit.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
by ajlanemed at Sept. 6, 2022, 8:53 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
ajlanemed
Highly Voted 2 years, 4 months ago
here is the sequence : 2-3-4
upvoted 263 times
627628c
2 days, 1 hour ago
This is correct, I tested it in PBI. You cannot "Select Department and Product and Unpivot Others" first, because Department and Product are not the column headers, you can't select them.
upvoted 1 times
...
Mfmx2024
1 month, 1 week ago
can someone please tell if this is correct answer in the exam ? I believe its 2-3-4
upvoted 2 times
...
oogrio
1 year, 10 months ago
I believe this is better than pivoting first too.
upvoted 6 times
...
olajor
2 years, 4 months ago
this is correct
upvoted 8 times
...
...
j0gam0d
Highly Voted 2 years, 3 months ago
Select Use First Row as Headers Select Department and Product and Unpivot Other Column Rename the Attribute column to YEAR and the Value column to REVENUE
upvoted 182 times
KMS111
7 months, 1 week ago
This is correct steps
upvoted 1 times
...
Inesd
8 months ago
agree, that's correct
upvoted 1 times
...
Amont1
1 year, 7 months ago
Correct!
upvoted 2 times
...
...
jaume
Most Recent 1 month, 3 weeks ago
Agree to 2-3-4 order for the answer. You cannot "Select Deparment and Product and Unpivot other columns) if you previously have not "Selected Use first row as headers" previously as columns to select are originally "Column1" and "Column2"not "Department" and Product" so actions in the proposed solution are the right ones in my opinion, but the order is not
upvoted 2 times
...
nelrosell
4 months, 3 weeks ago
The answer is wrong, have you tried your sequence? did you get a correct result? it has to be 2,3,4
upvoted 1 times
...
rcaliandro
4 months, 3 weeks ago
1 - Select Use First Row as Headers 2 - Select Depertment and Product and Unpivot Other Columns 3 - Rename the Attribute column to Year and the Value column to Revenue
upvoted 2 times
...
00c7ee4
4 months, 3 weeks ago
la secuencia es 2-3-4
upvoted 1 times
...
9f73003
8 months, 4 weeks ago
My question, where did they even get the answers they are showing from?? I can't believe I paid for this thing!!
upvoted 8 times
...
Dani_eL
10 months, 2 weeks ago
Using Power Query : If you follow the sequence of the answer you will have in Attribute column (column3) the following textual values: column3 column4 column5 column6 ... If you First row as headers first, you will have in Attribute column (column3) the following textual values: 2016 2017 2018 2019 ... which is what we want right ? the right sequence is : 2-3-4
upvoted 3 times
mycorgiart
4 months ago
Yes, I tried and got the same!
upvoted 1 times
...
...
KKPanda77
11 months ago
It should be 3,4,2
upvoted 1 times
nelrosell
4 months, 3 weeks ago
don't guess your answer, tried it then you will see
upvoted 1 times
...
Rhugved
10 months, 1 week ago
No it is 2,3,4
upvoted 2 times
...
...
__Sai_Mounika__
11 months, 1 week ago
Refer Q19
upvoted 1 times
...
Stayhardson
12 months ago
who the F give such stupid answer actually? should be B>C>D!
upvoted 5 times
...
euchrid
1 year, 1 month ago
Have to do First Rows as Headers first - you can't select the Department and Product columns if there aren't any columns with those names.
upvoted 6 times
cs3122
11 months, 4 weeks ago
very good reason as to why you cannot unpivot first
upvoted 1 times
...
...
cokimon
1 year, 1 month ago
People are suggesting Use first row as headers. Wouldn't that make 2016 a header and then you would have numerous headers (one for each year) ?
upvoted 1 times
...
acvribeiro
1 year, 2 months ago
Use first rows as headers Select Department and Product and unpivot the other columns Rename the attribute to year and Value to Revenue. I have tested it.
upvoted 5 times
...
T1M2P
1 year, 2 months ago
I tried with sample data the correct answer is. 2-3-4
upvoted 3 times
...
sankeytm
1 year, 3 months ago
Tried in Power Query - correct sequence is 2-3-4
upvoted 4 times
...
itenginerd
1 year, 3 months ago
This one took me a minute to understand. I wanted it to be 3-2-4, but it's 2-3-4. You have to use the first row as headers FIRST so that you have a department and product column to unpivot from.
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago