Question 510
A data analyst is planning a Power BI solution. The business says: A staging query shows a key column with 40% empty values and the model assumes it uniquely identifies each record. Which step best satisfies this request?
Explanation
Correct Answer
This directly addresses the stated constraint. Column profiling can reveal completeness and uniqueness problems before modeling. Confirmation: A validated nonblank unique key or documented composite key is used for relationships.
Incorrect Answers
Pivoting the three month fields again preserves the unsuitable wide layout. The specific problem here is that assigning a one-side relationship on a mostly null nonunique identifier produces incorrect modeling.
Blindly converting the column to Decimal Number produces unexamined conversion errors. The specific problem here is that assigning a one-side relationship on a mostly null nonunique identifier produces incorrect modeling.
A full outer join unintentionally includes CRM-only customers outside the required population. The specific problem here is that assigning a one-side relationship on a mostly null nonunique identifier produces incorrect modeling.