CSA Data Modeling and Management 2 — Questions and Answers
Question 1: Which field type should be used to store a unique identifier that is automatically generated by Salesforce for each record?
- Auto Number (Correct answer)
- Formula
- Text (Unique)
- External ID
Correct answer: Auto Number
Auto Number fields automatically generate a unique, sequential number for each record, formatted as defined by the admin.
Question 2: A company wants to track the total value of all related Opportunity line items on the Opportunity record. Which field type accomplishes this?
- Roll-Up Summary (Correct answer)
- Formula
- Currency
- Cross-Object Formula
Correct answer: Roll-Up Summary
Roll-Up Summary fields aggregate child record values (SUM, COUNT, MIN, MAX) and display the result on the parent record.
Question 3: What happens to child records in a lookup relationship when the parent record is deleted?
- Child records remain with the lookup field set to null (Correct answer)
- Child records are deleted along with the parent
- Child records are reassigned to another parent automatically
- The delete is prevented until children are removed
Correct answer: Child records remain with the lookup field set to null
In a lookup relationship, deleting the parent record does not delete children; the lookup field on child records is cleared.
Question 4: Which of the following is a key difference between a picklist and a multi-select picklist field?
- Multi-select picklist allows users to select more than one value (Correct answer)
- Picklists support record types while multi-select picklists do not
- Multi-select picklist values are stored as numbers
- Picklists cannot be used in reports
Correct answer: Multi-select picklist allows users to select more than one value
Multi-select picklists allow users to choose multiple values simultaneously, whereas standard picklists allow only a single value.
Question 5: An administrator needs to ensure that no two Account records share the same Tax ID number. Which field setting enforces this?
- Unique checkbox on the field definition (Correct answer)
- Required checkbox on the field definition
- External ID checkbox on the field definition
- Default Value on the field definition
Correct answer: Unique checkbox on the field definition
Enabling the Unique attribute on a custom field prevents duplicate values from being saved in that field across records.
Question 6: Which object relationship type allows the child record to be included in the parent record's page layout and detail view by default?
- Master-Detail (Correct answer)
- Lookup
- Many-to-Many (Junction Object)
- Hierarchical
Correct answer: Master-Detail
Master-Detail relationships enable related lists and roll-up summaries, and the child record's ownership and sharing follow the parent.
Question 7: What is the maximum number of custom fields allowed on a standard Salesforce object in most editions?
- 500 (Correct answer)
- 100
- 250
- 750
Correct answer: 500
Salesforce allows up to 500 custom fields per standard object in most editions, though some limits vary by object and edition.
CSA Data Modeling and Management 2
Which field type should be used to store a unique identifier that is automatically generated by Salesforce for each record?