Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam PL-300 Topic 1 Question 58 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 58
Topic #: 1
[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?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Kristel at Oct 18, 2024, 06:55 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Broderick
1 months ago
If the data is too long, you can always just shorten the column. Problem solved!
upvoted 0 times
Yuki
11 days ago
That's a good idea, it will help us analyze the frequency distribution without affecting the model size.
upvoted 0 times
...
Albina
14 days ago
C) From Power Query Editor, add a column that calculates the length of col1
upvoted 0 times
...
Arlette
23 days ago
A) In the report, add a DAX calculated column that calculates the length of col1
upvoted 0 times
...
...
Leanora
2 months ago
I heard Power BI can also calculate the length of your hair. Gotta keep that model lean and mean!
upvoted 0 times
Paulina
17 days ago
That's interesting! Power BI can do a lot of things, but I don't think it can calculate hair length.
upvoted 0 times
...
Mabel
27 days ago
C) From Power Query Editor, add a column that calculates the length of col1
upvoted 0 times
...
Sol
29 days ago
A) In the report, add a DAX calculated column that calculates the length of col1
upvoted 0 times
...
...
Tuyet
2 months ago
Option D? Seriously? Grouping by length? That's like trying to catch a fish with your bare hands. Power Query is the obvious choice here.
upvoted 0 times
...
Carin
2 months ago
Hmm, I was thinking of using a DAX calculated column, but you're right, that might increase the model size. Power Query is definitely the way to go!
upvoted 0 times
Mirta
1 months ago
C) From Power Query Editor, add a column that calculates the length of col1
upvoted 0 times
...
Claudia
1 months ago
A) In the report, add a DAX calculated column that calculates the length of col1
upvoted 0 times
...
...
Gilbert
2 months ago
I agree with Tasia. Power Query is the right place to handle this data transformation without impacting the model.
upvoted 0 times
...
Tasia
2 months ago
Option C is the way to go! Adding a column in Power Query is the best solution to avoid bloating the model size.
upvoted 0 times
Clarinda
1 months ago
User4: Let's go with option C then. From Power Query Editor, add a column that calculates the length of col1.
upvoted 0 times
...
Michel
1 months ago
User3: Agreed. It's the best solution for analyzing the frequency distribution of string lengths.
upvoted 0 times
...
Tamra
2 months ago
User2: That's a good idea. It won't affect the size of the model.
upvoted 0 times
...
Kallie
2 months ago
User1: I think we should add a column in Power Query to calculate the length of col1.
upvoted 0 times
...
...
Valentin
2 months ago
I prefer option A) In the report, add a DAX calculated column that calculates the length of col1. It gives more flexibility in the report.
upvoted 0 times
...
Dortha
2 months ago
I agree with Doretha. Adding a column in Power Query Editor is the most efficient way to analyze the frequency distribution.
upvoted 0 times
...
Doretha
3 months ago
I think the best option is C) From Power Query Editor, add a column that calculates the length of col1.
upvoted 0 times
...

Save Cancel
a