Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Vote for Option "D"
D. From Power Query Editor, change the distribution for the Column profile to group by length for col1 You want to analyze the frequency distribution of string lengths without increasing the model size. Adding calculated columns in either DAX (Options A and B) or Power Query (Option C) will increase the model size by adding data. Using Column Profile’s grouping by length in Power Query is a data profiling feature that lets you analyze length distribution without adding any columns or data to the model, so it won’t increase model size. This is the best approach for exploratory analysis of data shape/frequency without impacting the model.
To the moderator- please disregard this question. I found it already.