SF-Data-Arch Data Modeling and Database Design Practice Question
A Salesforce architect is designing a data model for a custom object 'Case__c' that needs to track the priority of each case. The priority values must be limited to a predefined list: Low, Medium, High, and Critical. Users should be able to select only one value, and the values should be easily reportable. Which field type should be used?
⚠ Common exam trap
The trap here is assuming that a Multi-select Picklist or a custom object lookup is needed for a simple single-select list, when a standard Picklist suffices.
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
✓
Picklist
A Picklist field is designed to allow a single selection from a predefined list of values, making it ideal for the priority field. It is easily reportable and enforces the one-value constraint. The other options either allow multiple selections, require custom validation, or introduce unnecessary complexity with a custom object.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Picklist
Why this is correct
A Picklist field allows users to select a single value from a predefined list of options. It is easily reportable, as each value is stored as a string and can be used in filters and groupings. This exactly matches the requirement to limit values to Low, Medium, High, and Critical and to allow only one selection, making it the correct choice.
- ✗
Lookup relationship to a custom object 'Priority__c'
Why it's wrong here
A Lookup relationship to a custom object would allow users to select a priority record, but it introduces unnecessary complexity for a simple predefined list. It requires creating and maintaining a custom object and records, and it may not be as straightforward for reporting as a Picklist. This option is overkill for the requirement and not the best design choice.
- ✗
Text field with a validation rule
Why it's wrong here
A Text field with a validation rule can restrict values to a predefined list, but it is not as user-friendly as a Picklist and requires custom validation logic. It also lacks the built-in UI for selection and may not be as easily reportable in terms of standard picklist reporting features. This option is less efficient and more error-prone than a Picklist.
- ✗
Multi-select Picklist
Why it's wrong here
A Multi-select Picklist allows users to select multiple values from a list, which violates the requirement that users should select only one value. While it is reportable, it stores multiple values in a single field, complicating reporting and not matching the one-value constraint. Therefore, it is not suitable for this scenario.
About these practice questions
One of 222 original SF-Data-Arch practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Salesforce exam blueprint
This SF-Data-Arch 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 SF-Data-Arch exam.