Microsoft Exam PL-300 Topic 1 Question 58 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 58
Topic #: 1

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?

AIn the report, add a DAX calculated column that calculates the length of col1

BIn the report, add a DAX function that calculates the average length of col1

CFrom Power Query Editor, add a column that calculates the length of col1

DFrom Power Query Editor, change the distribution for the Column profile to group by length for col1

Show Suggested Answer

Suggested Answer: B

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

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 days 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

...

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

...

8 days 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

...

9 days ago

I think the best option is C) From Power Query Editor, add a column that calculates the length of col1.

upvoted 0 times

...