Question

An analyst is preparing a customer orders dataset before loading it into a reporting warehouse. Business requirements state that every order's 'quantity' field must be a positive integer between 1 and 500, and 'order_date' cannot be in the future. During preparation, the analyst wants to ensure the incoming records comply with these documented constraints before the load runs. Which data quality activity should the analyst perform?

Accepted Answer

Apply validation rules (range and logic checks) to flag records where quantity falls outside 1–500 or order_date is later than today

Answer

Normalize the quantity column to a 0–1 scale so all values fit within an acceptable range

Answer

Pivot the dataset from long to wide format to make the quantity and date fields easier to compare

Answer

Perform a left join with a reference table to append missing customer attributes