Free practice · single-choice · medium
Practice
Apply an approved state mapping
The approved rule trims spaces, ignores case, and maps CA or California to CA. What should the raw value ' california ' become?
Confirmed duplicate · cleaning reconciliation
A controlled removal changes rows and revenue predictably
Row control
Raw4 rows
Clean3 rows
Revenue control
Raw$335
Clean$235
The $100 difference equals the one confirmed extraction duplicate; the raw layer and cleaning log remain preserved.