CSA Data Modeling and Management 4 — Questions and Answers
Question 1: An administrator needs to import 50,000 Account records and update existing records based on a unique field. Which tool is most appropriate?
- Data Loader (Correct answer)
- Data Import Wizard
- Reports
- Mass Transfer Records
Correct answer: Data Loader
Data Loader supports upsert operations on large volumes of records (up to 5 million) and can match on External ID fields.
Question 2: What is the maximum number of master-detail relationships a single custom object can have?
- Two (Correct answer)
- One
- Three
- Five
Correct answer: Two
A custom object can have up to two master-detail relationship fields, allowing it to serve as a junction object.
Question 3: Which field type would you use to capture long blocks of text, such as a detailed description, that may exceed 255 characters?
- Long Text Area (Correct answer)
- Text
- Rich Text Area
- Text Area
Correct answer: Long Text Area
Long Text Area fields support up to 131,072 characters and are appropriate for lengthy plain-text content.
Question 4: An admin wants child records to be deleted when the parent is deleted. Which relationship type enforces this behavior?
- Master-Detail (Correct answer)
- Lookup
- Hierarchical
- External Lookup
Correct answer: Master-Detail
In a master-detail relationship, deleting the parent record triggers a cascade delete of all related child records.
Question 5: What does enabling the 'Allow Reports' checkbox on a custom object do?
- Enables the object to be used in custom report types (Correct answer)
- Automatically generates standard reports for the object
- Gives all users read access to the object
- Allows the object to appear in list views
Correct answer: Enables the object to be used in custom report types
Checking 'Allow Reports' makes the object available as a primary or related object when creating custom report types.
Question 6: A company tracks Contacts at multiple Accounts (e.g., a consultant working for several clients). Which Salesforce feature supports this scenario?
- Contacts to Multiple Accounts (Correct answer)
- Junction Object
- Many-to-Many Relationship
- Account Teams
Correct answer: Contacts to Multiple Accounts
The 'Contacts to Multiple Accounts' feature allows a Contact to be directly related to multiple Account records via a relationship record.
Question 7: Which statement about formula fields is correct?
- Formula field values are calculated at runtime and not stored in the database (Correct answer)
- Formula fields can be used as the controlling field for dependent picklists
- Formula fields support write operations via the API
- Formula fields can reference fields on grandchild objects
Correct answer: Formula field values are calculated at runtime and not stored in the database
Formula fields are computed dynamically each time a record is displayed and do not occupy storage in the database.
CSA Data Modeling and Management 4
An administrator needs to import 50,000 Account records and update existing records based on a unique field.
Which tool is most appropriate?