PLAT-101 practice question 7 of 10

Get Cloudy Consulting wants to group its contacts by region. On most records, this text field is blank or misspelled. Which action is recommended to ensure there is correct data for this field?

Full set: 123 questions
Answer options
A: Convert the Region field to a picklist field. Correct answer
B: Create a validation rule to enforce correct spelling.
C: Email users a list of region names with correct spelling.
Correct Answer:
A. Convert the Region field to a picklist field.
Explanation

Converting an existing text field to a picklist field is the recommended best practice in Salesforce to enforce standardized data entry and eliminate misspellings or inconsistent values. When a field is a free-form text field, users can enter arbitrary strings, leading to blank or misspelled entries that complicate grouping and reporting. By converting the field to a custom picklist, administrators define a controlled, standardized list of valid region values for users to select. This prevents manual typographical errors, ensures uniform data categorization, improves overall data quality, and simplifies standard reporting across all Contact records. Additionally, standard picklist fields can be required, ensuring the region is consistently captured during record creation and editing.

Why Incorrect

B. Create a validation rule to enforce correct spelling: A validation rule on a standard text field cannot dynamically check complex arbitrary spellings without hardcoding every variation, making it inefficient compared to a standard picklist field.
C. Email users a list of region names with correct spelling: Emailing users relies on manual compliance, which does not prevent typos or blank entries within Salesforce, failing to programmatically enforce data integrity.

References

Salesforce Help: Custom Field Types Overview, Section "Picklist Fields and Standardized Data Entry", Salesforce Documentation.

Salesforce Trailhead Module: Data Quality, Unit "Enhance Data Quality with Standardized Picklists".

Scroll to Top