Question 410
A data analyst is planning a Power BI solution. The business says: An inventory export contains rows with empty required SKU values but valid nonrequired descriptions. Which step best satisfies this request?
Explanation
Correct Answer
This directly addresses the stated constraint. Column-specific completeness requirements should govern data cleaning. Confirmation: The loaded fact table has no blank SKU keys, and rejected records are auditable.
Incorrect Answers
Arbitrary Remove Duplicates before choosing a revision can retain stale line values. The specific problem here is that removing all rows containing any blank cell discards legitimate partially populated descriptions.
Changing only the display format leaves mismatched underlying text/integer key types. The specific problem here is that removing all rows containing any blank cell discards legitimate partially populated descriptions.
Treating a duplicate lookup as one-to-many during enrichment can inflate fact rows. The specific problem here is that removing all rows containing any blank cell discards legitimate partially populated descriptions.