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 1 discussion

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

You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

  • A. In the report, add a DAX calculated column that calculates the length of col1
  • B. In the report, add a DAX function that calculates the average length of col1
  • C. From Power Query Editor, add a column that calculates the length of col1
  • D. From Power Query Editor, change the distribution for the Column profile to group by length for col1
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Muffinshow at Sept. 2, 2022, 3:44 p.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
Muffinshow
Highly Voted 2 years, 8 months ago
Selected Answer: D
Wrong answer, A will affect the size of the model as would C. B doesn't give you enough information about the distribution (just the average) D is the right answer.
upvoted 138 times
KARELA
1 year, 11 months ago
for D to be correct we need to calculate length of the strings in col1 beforehand so it is not correct
upvoted 1 times
sandipnair
1 year, 10 months ago
If you enable to column profile from view menu, you can actually group the distribution by text length. It is not grouping the actual column, rather just grouping the distribution.
upvoted 18 times
...
...
GPerez73
2 years, 7 months ago
I agree
upvoted 2 times
...
Hoeishetmogelijk
2 years, 5 months ago
I agree completely!
upvoted 2 times
...
Jonagan
2 years, 5 months ago
Why do you think that aggregating in the PowerQuery size will not influence the size of the datamodel? its getting smaller isnt it? Measures are the only solutions that does not influence the datamodel. They require CPU but but does not store additional data or does not reduce the data in the model
upvoted 17 times
Elektrolite
1 year, 1 month ago
D is not aggregating in power query, it's viewing the column profile
upvoted 3 times
...
GabryPL
2 years, 3 months ago
Option B is also correct for me it's the only one that will not affect the size of the model
upvoted 7 times
Mubarakbabs
2 years, 3 months ago
Yes, option B will not affect the size of the model, but it won't show us the frequency distribution, which is what we really need. Option D doesn't create any new column, it only changes how the column distribution is displayed, so it won't affect the size of the model
upvoted 12 times
lizbette
2 years ago
why doesn't B affect the size of the model but A does?
upvoted 4 times
...
...
...
Kai_don
2 years, 4 months ago
Option A is saying useing calculated column which increases the size of the model. So D is correct.
upvoted 5 times
...
...
...
lukelin08
Highly Voted 2 years, 6 months ago
Selected Answer: D
Its D, this can easily be tested by going to Power Query Editor > View > Column Profile > distribution graph, click the three little dots and select group by text length. This will allow you to view the distribution of text length within the column
upvoted 81 times
eloomis
2 years, 2 months ago
The problem is this method doesn't make the distribution analyzable in the report, which I think is what the question is getting at. It will show you the distribution but you need a dax measure to place in your report to visualize that. I would go with option B as it creates a measure which you can use in the report, and it doesn't contribute to the size of the model as with A.
upvoted 7 times
...
HemantGorle
2 years, 3 months ago
D is correct and it can be tested by following step mentioned by Lukelin08
upvoted 2 times
...
cs3122
1 year, 3 months ago
Thank you, just tested and it works. D has to be the answer, as it doesn't impact the model size
upvoted 1 times
...
miro26
1 year, 9 months ago
Make sure your column type is not "variant" ;)
upvoted 2 times
...
...
e5accfd
Most Recent 4 weeks ago
Selected Answer: D
Open the PQE enable the Column Distribution in View ribbon, click on the ellipses in the bottom Bar chart box Group By > Text length
upvoted 1 times
...
Minh2712
1 month, 1 week ago
Selected Answer: D
D is the correct answer
upvoted 1 times
...
MANANDAVEY
3 months, 2 weeks ago
Selected Answer: D
It's very simple and logical AB,C will increase the model size so D is the right answer.
upvoted 1 times
...
Kleeneeex
4 months ago
Selected Answer: D
Changing the column profile distribution in Power Query Editor allows you to analyze the frequency distribution of string lengths without permanently modifying or adding new data. This operation is exploratory and does not affect the data loaded into the model or the size of the model.
upvoted 1 times
...
jaume
5 months, 2 weeks ago
Selected Answer: D
Totally agree with lukelin98 who is also providing detiled steps to analyze frequency distribution of the string length. A and C solutions add columns to our model so are increasing its size. Solution B is returning one single value (the average lenght) and that's not something you can use to analyze any frequency
upvoted 1 times
...
ae8a90c
6 months, 3 weeks ago
Selected Answer: D
option D is correct
upvoted 1 times
...
ykb_proudly_Indian
7 months ago
C: Tried and tested Transform Data -> Add Column -> Extract -> Length
upvoted 1 times
ykb_proudly_Indian
7 months ago
As adding a Column can increase the model size, so this option does not work here.
upvoted 1 times
...
...
itGoat
7 months ago
calculted columns will increase the size of the models so those are out and the other is finding the average leavind D as correct
upvoted 1 times
...
rcaliandro
8 months, 2 weeks ago
Selected Answer: D
for me is D. From Power Query Editor, change the distribution for the Column profile to group by length for col1
upvoted 2 times
rcaliandro
8 months, 1 week ago
Tested it is D for sure. In power Query Editor, View check column profile. There is the possibility to group by value or text lenght. Choose text lenght and this will show the lenght of col1
upvoted 1 times
...
...
Datanoob101
8 months, 3 weeks ago
Selected Answer: D
Upon a little research it turns out that calculated columns=larger data models. Option A & C: both introduce a new column. Will affect the size of the model. Option B: As muffin show and mubarakbabs stated above, it doesn't give us enough info (only avg) Ans must be D.
upvoted 2 times
...
Kiran37
9 months, 1 week ago
correct answer
upvoted 1 times
...
yaya32
11 months, 3 weeks ago
Selected Answer: D
D for me
upvoted 1 times
...
RoxyRishi
12 months ago
I also think D as it won't affect the data model size
upvoted 1 times
...
9f73003
1 year ago
D. It says to analyze, which means in the context of this question, look at to determine. It also states it must not affect the model size. A calculated dax column will affect size of the model. D is perfect, because with the column profile tool you able to see the exact information that are looking for.
upvoted 1 times
...
AZFabio
1 year, 1 month ago
Selected Answer: A
A is right, but B looks correct to me as well
upvoted 2 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