Universal Containers (UC) sells mostly to the North American market. A consultant is studying the spending habits of UC's customers where the consultant collects the data with a Region column that is 94% North America, 3% Rest of the World, 3% null. What is the appropriate action to take?

A. Leave the data as-is, let Discovery deal with nulls.
B. Replace the nulls with "Rest of the World" since Discovery rejects nulls.
C. Replace the nulls with North America since they are likely "North America".
D. Drop the column since there is no valuable information from the column.

Suggest answer: C

Reference: