Question: One of your data columns includes the city, state, and postal code line of a mailing address. You need to separate the fields so you can access the geospatial elements for a map visualization. What transformation should you apply?

  1. Replace values
  2. Split column
  3. Modify data type
  4. Best fit geospatial

Answer: The correct answer of the above question is Option B:Split column