CSA Data Modeling and Management 3 — Questions and Answers
Question 1: A Salesforce admin wants to prevent users from saving a Contact without a related Account. Which approach achieves this without code?
- Change the Account lookup to a master-detail relationship
- Make the Account Name field required on the Contact layout
- Create a validation rule requiring Account ID to be non-null (Correct answer)
- Use a workflow rule to enforce the relationship
Correct answer: Create a validation rule requiring Account ID to be non-null
A validation rule using ISBLANK(AccountId) will block the save and display an error message if no Account is linked.
Question 2: Which data type is best suited for storing a phone number that should be clickable on mobile devices?
- Phone (Correct answer)
- Text
- URL
- Formula
Correct answer: Phone
The Phone field type formats numbers correctly and enables click-to-call functionality on mobile devices.
Question 3: An admin creates a junction object to model a many-to-many relationship. How many master-detail relationships does the junction object have?
- Two (Correct answer)
- One
- Three
- Zero
Correct answer: Two
A junction object has two master-detail relationships, one to each of the two parent objects it connects.
Question 4: Which statement about schema builder is TRUE?
- It allows admins to create and edit objects and fields visually (Correct answer)
- It is only available in Salesforce Classic
- It requires Apex knowledge to use
- It can only view existing objects, not create new ones
Correct answer: It allows admins to create and edit objects and fields visually
Schema Builder provides a drag-and-drop canvas to create objects, fields, and relationships without navigating multiple setup pages.
Question 5: What is the purpose of the 'External ID' attribute on a custom field?
- It allows the field to be used as a match key during data import upserts (Correct answer)
- It makes the field visible to external users only
- It stores IDs from external authentication providers
- It prevents the field from being included in API queries
Correct answer: It allows the field to be used as a match key during data import upserts
Marking a field as External ID enables it to be used as a unique key for upsert operations in the Data Loader and APIs.
Question 6: A company needs a field that displays the number of days since an Opportunity was last modified. Which field type is most appropriate?
- Formula (Number) (Correct answer)
- Roll-Up Summary
- Auto Number
- Currency
Correct answer: Formula (Number)
A Formula field using TODAY() - LastModifiedDate calculates and displays a dynamic value without storing it separately.
Question 7: Which Salesforce feature allows an admin to define dependencies between picklist values so that selecting one value filters the options in another picklist?
- Dependent Picklists (Correct answer)
- Controlling Fields
- Dynamic Forms
- Conditional Visibility
Correct answer: Dependent Picklists
Dependent picklists link a controlling field to a dependent field, filtering available values based on the controlling field's selection.
CSA Data Modeling and Management 3
A Salesforce admin wants to prevent users from saving a Contact without a related Account.
Which approach achieves this without code?