CSA Data Modeling and Management 5 — Questions and Answers
Question 1: An admin needs to enforce that an Opportunity's Close Date cannot be set in the past when a new record is created. Which tool should be used?
- Validation Rule (Correct answer)
- Required Field Setting
- Workflow Rule
- Approval Process
Correct answer: Validation Rule
A validation rule using ISNEW() && CloseDate < TODAY() will prevent new Opportunity records from having a past Close Date.
Question 2: What is the primary purpose of the Data Import Wizard in Salesforce?
- To import data for standard and custom objects with a guided, browser-based interface (Correct answer)
- To perform bulk deletes of records
- To schedule automated data exports
- To synchronize data between Salesforce orgs
Correct answer: To import data for standard and custom objects with a guided, browser-based interface
The Data Import Wizard provides a step-by-step UI for importing up to 50,000 records for supported standard and custom objects.
Question 3: Which object in Salesforce stores the relationship between a Contact and a secondary Account when 'Contacts to Multiple Accounts' is enabled?
- AccountContactRelation (Correct answer)
- ContactAccountLink
- RelatedContact
- ContactRole
Correct answer: AccountContactRelation
The AccountContactRelation object stores the indirect relationships between Contacts and additional Accounts beyond the primary Account.
Question 4: An administrator wants to prevent a record from being saved if a required custom field is left blank. Without using code, what is the best method?
- Mark the field as Required in the field definition or page layout (Correct answer)
- Create an after-save trigger
- Use a workflow rule to validate the field
- Enable field-level security to enforce the field
Correct answer: Mark the field as Required in the field definition or page layout
Setting a field as Required either at the field definition level or on the page layout prevents record saves when the field is empty.
Question 5: Which of the following field types CANNOT be used as a controlling field for a dependent picklist?
- Multi-Select Picklist (Correct answer)
- Checkbox
- Standard Picklist
- Custom Picklist
Correct answer: Multi-Select Picklist
Multi-select picklist fields cannot act as controlling fields; only standard picklists and checkbox fields can control dependent picklists.
Question 6: What is the effect of converting a lookup relationship to a master-detail relationship on existing records?
- All existing child records must have a populated lookup value before conversion is allowed (Correct answer)
- Existing child records are automatically deleted if the lookup field is empty
- The conversion fails if any child record has data in the lookup field
- Existing records are unaffected because master-detail has no parent requirement
Correct answer: All existing child records must have a populated lookup value before conversion is allowed
Salesforce requires all existing child records to have a value in the lookup field before it can be converted to a master-detail relationship.
Question 7: An admin is designing a data model for a custom object that must support roll-up summary fields from a child object. What type of relationship must exist between the two objects?
- Master-Detail with the custom object as the master (Correct answer)
- Lookup with the custom object as the parent
- Many-to-Many via a junction object
- Hierarchical relationship on the custom object
Correct answer: Master-Detail with the custom object as the master
Roll-Up Summary fields are only available on the master (parent) side of a master-detail relationship.
CSA Data Modeling and Management 5
An admin needs to enforce that an Opportunity's Close Date cannot be set in the past when a new record is created.
Which tool should be used?