Profile and clean the data
5 practice questions under this official exam objective (PL-300) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Adding 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
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