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 questionsA 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.
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.
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.
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
