Question 270
Incident review: An inventory export contains rows with empty required SKU values but valid nonrequired descriptions. The team implemented the intended Power BI workflow but the acceptance test failed. Which defect should it investigate?
Explanation
Correct Answer
This defect explains why the required behavior failed. Column-specific completeness requirements should govern data cleaning. The corrective action is: Filter or remediate only records violating the required key rule and log rejected SKU rows.
Incorrect Answers
Removing duplicates by invoice date alone deletes legitimate sales occurring on the same day. The stated evidence instead indicates: Removing all rows containing any blank cell discards legitimate partially populated descriptions.
Aggregating all sales to customer grain prematurely removes product line analysis. The stated evidence instead indicates: Removing all rows containing any blank cell discards legitimate partially populated descriptions.
A blind unpivot without correcting orientation leaves attributes as record identifiers. The stated evidence instead indicates: Removing all rows containing any blank cell discards legitimate partially populated descriptions.