SP Database Management 3 — Questions and Answers
Question 1: Which Salesforce feature enables real-time data synchronization between Salesforce and an external database without storing data in Salesforce?
- Heroku Connect
- External Objects via Salesforce Connect (Correct answer)
- Data Import Wizard
- Platform Events
Correct answer: External Objects via Salesforce Connect
Salesforce Connect with External Objects lets users view and search external data in real time without importing it into Salesforce.
Question 2: What is the purpose of a junction object in Salesforce data modeling?
- To enforce field-level security between two objects
- To create a many-to-many relationship between two objects (Correct answer)
- To roll up values from child to parent
- To replace lookup fields with formula fields
Correct answer: To create a many-to-many relationship between two objects
A junction object has two master-detail relationships pointing to different parent objects, enabling many-to-many data relationships.
Question 3: Which governor limit governs the total number of SOQL queries that can be issued in a single Apex transaction?
- 50 SOQL queries per transaction
- 100 SOQL queries per transaction (Correct answer)
- 200 SOQL queries per transaction
- 500 SOQL queries per transaction
Correct answer: 100 SOQL queries per transaction
Salesforce enforces a limit of 100 SOQL queries per synchronous Apex transaction to prevent excessive database calls.
Question 4: What is the primary use case for Salesforce Big Objects?
- Replacing standard objects with higher field limits
- Storing and querying massive volumes of historical data (Correct answer)
- Creating hierarchical data structures
- Enabling real-time external data access
Correct answer: Storing and querying massive volumes of historical data
Big Objects are designed to store and query billions of records of historical or archival data within Salesforce.
Question 5: A developer wants to prevent duplicate Account records from being created based on the Account Name field. Which Salesforce feature should be configured?
- Validation Rules
- Duplicate Management with Matching Rules (Correct answer)
- Required Fields
- Workflow Rules
Correct answer: Duplicate Management with Matching Rules
Duplicate Management uses Matching Rules to identify potential duplicates and Duplicate Rules to block or alert on them.
Question 6: In SOSL (Salesforce Object Search Language), which keyword is used to specify which objects and fields to search?
- FROM
- RETURNING (Correct answer)
- IN
- SELECT
Correct answer: RETURNING
The RETURNING keyword in SOSL specifies which objects and fields should be included in the search results.
Question 7: Which field type in Salesforce automatically maintains a historical log of changes made to its value?
- Formula Field
- Text Area (Long)
- Field History Tracking enabled field (Correct answer)
- Encrypted Field
Correct answer: Field History Tracking enabled field
When Field History Tracking is enabled on a field, Salesforce automatically logs changes including old value, new value, date, and user.
SP Database Management 3
Which Salesforce feature enables real-time data synchronization between Salesforce and an external database without storing data in Salesforce?