CSA Standard & Custom Objects 3 — Questions and Answers
Question 1: A custom object has a Lookup relationship to Account. If the Account is deleted, what happens to the custom object records by default?
- Custom object records are deleted
- Custom object records are archived
- The lookup field is cleared (set to null) (Correct answer)
- Deletion of the Account is blocked
Correct answer: The lookup field is cleared (set to null)
In a Lookup relationship, deleting the parent clears the lookup field on child records rather than deleting them, unlike Master-Detail.
Question 2: Which field type stores a reference to a user, queue, or public group and is commonly used for record assignment?
- Text
- Lookup (User) (Correct answer)
- Hierarchy
- Owner field
Correct answer: Lookup (User)
A Lookup field referencing the User object allows storing assignment to a specific user, and combined with queues, supports flexible record routing.
Question 3: What distinguishes a 'Big Object' from a standard custom object in Salesforce?
- Big Objects support triggers and workflow rules
- Big Objects store massive amounts of data with limited querying via index fields (Correct answer)
- Big Objects appear in standard reports
- Big Objects can have Master-Detail relationships
Correct answer: Big Objects store massive amounts of data with limited querying via index fields
Big Objects are designed for archiving massive datasets and are queried via defined index fields using SOQL with specific syntax, not standard SOQL filters.
Question 4: An admin wants to prevent users from creating duplicate Account records based on the Account Name and billing city. Which Salesforce feature handles this?
- Validation Rules
- Duplicate Rules and Matching Rules (Correct answer)
- Unique field constraint
- Workflow Rules
Correct answer: Duplicate Rules and Matching Rules
Duplicate Rules work with Matching Rules to identify and block or alert users when records match existing data based on configured criteria.
Question 5: Which of the following objects supports the 'Person Account' feature when enabled?
- Lead
- Contact
- Account (Correct answer)
- Opportunity
Correct answer: Account
Person Accounts combine Account and Contact data into a single record on the Account object, used for B2C business models.
Question 6: A custom object named 'Project__c' needs a field showing the name of the related Account's Owner without a separate lookup. Which field type accomplishes this?
- Roll-Up Summary
- Cross-object formula (Correct answer)
- Lookup filter
- Related list
Correct answer: Cross-object formula
A cross-object formula field can traverse lookup and master-detail relationships to reference fields on related objects, like Account.Owner.Name.
Question 7: What is the purpose of the 'External ID' attribute on a custom field?
- It makes the field visible in external portals
- It allows the field to be used as a matching key during data imports and upserts (Correct answer)
- It encrypts the field value for external systems
- It exposes the field via REST API only
Correct answer: It allows the field to be used as a matching key during data imports and upserts
External ID fields serve as unique identifiers from external systems, enabling upsert operations in Data Loader and APIs to match records without Salesforce IDs.
A custom object has a Lookup relationship to Account.
If the Account is deleted, what happens to the custom object records by default?