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, 9 months ago
here is the sequence : 2-3-4
upvoted 276 times
627628c
5 months, 1 week 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 2 times
...
Mfmx2024
6 months, 2 weeks ago
can someone please tell if this is correct answer in the exam ? I believe its 2-3-4
upvoted 5 times
SylUK
4 months, 4 weeks ago
The given answer is correct which is 3-4-2, following the instructions: Firstly "You need to transform the data to ensure that you can build the visuals." Secondly " The solution must ensure that the columns are named appropriately for the data that they contain."
upvoted 1 times
...
...
oogrio
2 years, 3 months ago
I believe this is better than pivoting first too.
upvoted 6 times
...
olajor
2 years, 9 months ago
this is correct
upvoted 8 times
...
...
j0gam0d
Highly Voted 2 years, 9 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 183 times
KMS111
1 year ago
This is correct steps
upvoted 2 times
...
Inesd
1 year, 1 month ago
agree, that's correct
upvoted 2 times
...
Amont1
2 years ago
Correct!
upvoted 3 times
...
...
imenjmal9
Most Recent 4 months, 4 weeks ago
La réponse est 2-3-4
upvoted 2 times
...
jaume
7 months 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
10 months 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
10 months 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
10 months ago
la secuencia es 2-3-4
upvoted 1 times
...
9f73003
1 year, 2 months ago
My question, where did they even get the answers they are showing from?? I can't believe I paid for this thing!!
upvoted 9 times
...
Dani_eL
1 year, 3 months 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 4 times
mycorgiart
9 months, 1 week ago
Yes, I tried and got the same!
upvoted 1 times
...
...
KKPanda77
1 year, 4 months ago
It should be 3,4,2
upvoted 1 times
nelrosell
10 months ago
don't guess your answer, tried it then you will see
upvoted 1 times
...
Rhugved
1 year, 3 months ago
No it is 2,3,4
upvoted 2 times
...
...
__Sai_Mounika__
1 year, 4 months ago
Refer Q19
upvoted 1 times
...
Stayhardson
1 year, 5 months ago
who the F give such stupid answer actually? should be B>C>D!
upvoted 5 times
...
euchrid
1 year, 6 months 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
1 year, 5 months ago
very good reason as to why you cannot unpivot first
upvoted 1 times
...
...
cokimon
1 year, 6 months 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, 7 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, 7 months ago
I tried with sample data the correct answer is. 2-3-4
upvoted 3 times
...
sankeytm
1 year, 8 months ago
Tried in Power Query - correct sequence is 2-3-4
upvoted 4 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