DATA-ARCHITECT practice question 24 of 35

Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field: 1. High Value 2. Medium Value 3. Low Value Which strategy should a data architect recommend to configure customer type?

Full set: 257 questions
Answer options
A: Lookup to a custom object with defined choices.
B: Single-select restricted picklist with defined choices. Correct answer
C: Provide help text to guide users with defined choices.
D: Create a validation rule to limit entry to defined choices.
Correct Answer:
B. Single-select restricted picklist with defined choices.
Explanation

A single-select restricted picklist is the most appropriate solution. It declaratively enforces data integrity by limiting user input to a predefined list of values ("High Value," "Medium Value," "Low Value"). This approach is user-friendly, as it presents the choices in a dropdown menu, preventing typos and ensuring consistency for reporting. It directly meets the requirement to limit users to defined choices without custom code or complex configurations.

Why Incorrect

A. A lookup requires creating and maintaining a separate custom object, which is unnecessary overhead for a simple, static list of values.
C. Help text provides guidance but does not enforce data entry rules; users can still input any value they choose.
D. A validation rule can enforce the choices but is less user-friendly than a picklist, as it only provides an error message after an invalid entry.

References

1. Salesforce Help. (2023). Create a Custom Picklist Field. "Restrict picklists to only the values you define." Retrieved from Salesforce Help documentation.

2. Salesforce Help. (2023). Validation Rules. "Validation rules verify that the data a user enters in a record meets the standards you specify before the user can save the record." (This highlights its reactive nature compared to the proactive guidance of a picklist).

3. Salesforce Architects. (2022). Record-Level Security. In Salesforce Well-Architected. "Use restricted picklists to ensure that only approved values are used." Retrieved from architect.salesforce.com.

Scroll to Top