Courseiva
Data ManagementhardMultiple ChoiceObjective-mapped

Sales-Con-201 Data Management Practice Question

Universal Containers has thousands of legacy Account records containing messy address data. They want to standardize state and country values to ISO codes automatically during migration. What is the best approach?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Enable State and Country Picklists and use Data Loader to map standard values.

Enabling State and Country Picklists and mapping the legacy values to the integration values via the user interface or Data Loader ensures data integrity and adherence to standard formats.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Use workflow field updates to overwrite text entries.

    Why it's wrong here

    Workflow rules cannot dynamically map arbitrary text strings to standardized picklist values across diverse inputs.

  • Enable State and Country Picklists and use Data Loader to map standard values.

    Why this is correct

    State and Country Picklists provide native standardization, and Data Loader maps standard values or ISO codes directly.

  • Write a trigger to format text fields upon insert.

    Why it's wrong here

    Writing custom code is unnecessary and harder to maintain when native picklist features exist.

  • Rely on users to manually select the correct picklist value post-migration.

    Why it's wrong here

    Manual cleanup post-migration is prone to human error and low data adoption.

About these practice questions

This Sales-Con-201 question is part of Courseiva's 321-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written and reviewed by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

Last reviewed August 2026 · checked against the official Salesforce exam blueprint

This Sales-Con-201 practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Sales-Con-201 exam.