Free practice · numeric · medium
Practice
Profile order key uniqueness
A five-row extract contains four distinct order_id values. What is the distinct-key count as a percentage of rows?
Five-row order profile
A short profile exposes three different quality risks
- Rows
- 5 Source extract
- Distinct order IDs
- 4 One repeated key
- Approved statuses
- 3 One blank · one unexpected
Rows with a missing status20%
The duplicate key, blank status, and unapproved label must be investigated before shipped revenue is reported.