Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 1 discussion

Actual exam question from Microsoft's PL-300

Question #: 1
Topic #: 2

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

Suggested Answer: D 🗳️

by Muffinshow at Sept. 2, 2022, 3:44 p.m.

Comments

Submit Cancel

Muffinshow

Highly Voted 2 years, 9 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 139 times

KARELA

2 years, 1 month 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

2 years 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

mvgs27

3 weeks, 3 days ago

Sorry, how to do this?

upvoted 1 times

mvgs27

3 weeks, 3 days ago

To the moderator- please disregard this question. I found it already.

upvoted 1 times

...

GPerez73

2 years, 9 months ago

I agree

upvoted 2 times

...

Hoeishetmogelijk

2 years, 6 months ago

I agree completely!

upvoted 2 times

...

Jonagan

2 years, 7 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, 3 months ago

D is not aggregating in power query, it's viewing the column profile

upvoted 3 times

...

GabryPL

2 years, 5 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, 4 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, 1 month ago

why doesn't B affect the size of the model but A does?

upvoted 4 times

...

Kai_don

2 years, 5 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, 8 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, 3 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, 5 months ago

D is correct and it can be tested by following step mentioned by Lukelin08

upvoted 2 times

...

cs3122

1 year, 4 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, 10 months ago

Make sure your column type is not "variant" ;)

upvoted 2 times

...

lechuc508

Most Recent 1 month ago

Selected Answer: D

Column Profile is a feature in Power Query Editor that allows you to view statistical information about the data in a column (value distribution, column quality...). This information is displayed in the Power Query Editor interface and is NOT loaded into the final data model .

upvoted 1 times

...

d28dcc1

1 month, 1 week ago

Selected Answer: D

Answer is D. Do this: Power Query->View->Column Profile->Text Length Distribution->Top right bread crumbs-> Group By->Text Length

upvoted 1 times

...

e5accfd

2 months, 2 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

2 months, 3 weeks ago

Selected Answer: D

D is the correct answer

upvoted 1 times

...

MANANDAVEY

5 months 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

5 months, 2 weeks 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

7 months 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

8 months ago

Selected Answer: D

option D is correct

upvoted 1 times

...

ykb_proudly_Indian

8 months, 2 weeks ago

C: Tried and tested Transform Data -> Add Column -> Extract -> Length

upvoted 1 times

ykb_proudly_Indian

8 months, 2 weeks ago

As adding a Column can increase the model size, so this option does not work here.

upvoted 1 times

...

itGoat

8 months, 2 weeks 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

10 months 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

9 months, 4 weeks 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

10 months, 1 week 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

...