SP Database Management 2 — Questions and Answers
Question 1: Which Salesforce feature allows you to store large amounts of unstructured data such as documents and images directly linked to records?
- Files and Attachments (Correct answer)
- Custom Metadata Types
- Big Objects
- External Objects
Correct answer: Files and Attachments
Salesforce Files and Attachments allow users to store unstructured data like documents and images linked directly to records.
Question 2: What is the maximum number of custom fields allowed on a standard Salesforce object by default?
- 100
- 500
- 800 (Correct answer)
- 250
Correct answer: 800
Salesforce allows up to 800 custom fields on most standard objects by default.
Question 3: Which data type should be used for a Salesforce field that must store a unique identifier from an external system?
- Number
- Text (External ID) (Correct answer)
- Formula
- Encrypted Text
Correct answer: Text (External ID)
A Text field marked as External ID stores unique identifiers from external systems and can be used as an upsert key.
Question 4: When using Salesforce SOQL, what clause is used to filter query results based on a related object's field?
- JOIN
- INCLUDES
- WHERE with dot notation (Correct answer)
- HAVING
Correct answer: WHERE with dot notation
SOQL uses dot notation in the WHERE clause (e.g., Account.Name = 'Acme') to filter on related object fields.
Question 5: What Salesforce tool is best suited for deleting large volumes of records without hitting governor limits?
- Data Loader with bulk API (Correct answer)
- Developer Console
- SOQL Query Tool
- Apex Trigger
Correct answer: Data Loader with bulk API
Data Loader using the Bulk API can process up to 5 million records per batch, making it ideal for large-volume deletions.
Question 6: Which Salesforce relationship type does NOT copy child records when the parent record is cloned?
- Master-Detail
- Lookup (Correct answer)
- Many-to-Many (Junction)
- Hierarchical
Correct answer: Lookup
Lookup relationships are independent; cloning the parent does not automatically clone associated child records.
Question 7: In Salesforce, what happens to a roll-up summary field when the child records associated with a master record are deleted?
- The field retains the last calculated value
- The field recalculates automatically (Correct answer)
- The field is locked and shows an error
- The field reverts to zero without recalculation
Correct answer: The field recalculates automatically
Roll-up summary fields automatically recalculate when child records are deleted, always reflecting the current state.
SP Database Management 2
Which Salesforce feature allows you to store large amounts of unstructured data such as documents and images directly linked to records?