Exam PL-300 topic 1 question 47 discussion

Actual exam question from Microsoft's PL-300

Question #: 47
Topic #: 1

HOTSPOT
-

You have a Power BI semantic model.

You discover that the semantic model contains values that display as errors.

You need to use data profiling features in Power Query to preview the data and identify the issues.

What should you select to gain insight into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

Show Suggested Answer

Suggested Answer:

by Zander3 at Feb. 18, 2025, 10:44 p.m.

Comments

Submit Cancel

Mi4as

2 months, 3 weeks ago

"Replace error" is correct, but the first block doesn't have any useful option. "Column distribution" shows distinct/unique count - not help at all, and if we have an error(our case) it shows nothing. "Column quality" shows the per cent valid/error/empty. OK, we have 52% of errors and what? What we really need here that the "Column profile" which shows all the information to identify the scope of error and replace errors.

upvoted 1 times

BhavnishM

2 months, 1 week ago

both column quality and column profile are used to analyze errors. Since , column profile is not the an option, column quality is right.

upvoted 1 times

...

Zander3

3 months, 3 weeks ago

"Column quality" is what helps us gain insight because it shows the number of valid values, errors, and empty values in a column. For resolution, "Replace errors" would actually allow us to fix those errors, unlike options like "Remove duplicates" or "Remove empty," which don’t actually address the errors themselves.

upvoted 4 times

...