Profile and clean the data
7 practice questions under this official exam objective (PL-300), each with the answer key, an option-by-option explanation and instant feedback.
Questions under this objective
7 total · page 1 of 1Adding an index key and normalizing casing to resolve DirectQuery undefined values
For a case-sensitive column feeding a case-insensitive DirectQuery model that shows undefined values and errors, the proposed solution adds an index k
Fixing undefined values in a DirectQuery model by normalizing casing in the source query
A case-sensitive column produces undefined values and errors when consumed by a case-insensitive DirectQuery semantic model, and the proposed fix is t
Power Query Column Profiling for Text Length Analysis
This question tests the correct sequence of actions in Power Query Editor to profile a column's text length without modifying the underlying data. The
Replacing null freight amounts with zero to keep per-order averages correct
Sales order data is aggregated by month to produce average item quantity per order, average freight per order, and maximum item quantity per order, wh
Implicit type conversion cannot fix case-sensitivity errors in DirectQuery
Continuing the case-sensitive DirectQuery scenario, the proposed solution implicitly converts the values into the required type to resolve undefined v
Switching the semantic model mode does not resolve case-sensitivity undefined values
In the same case-sensitive scenario, the proposed solution changes the semantic model mode to eliminate the undefined values and errors found in the D
Merge Customer and Contacts with fuzzy matching in Power BI
This PL-300 scenario tests Power BI merge options for unsanitized contact data; the correct choice is to enable fuzzy matching (D) when merging Custom