PDI · Question #1
Universal Containers hires a developer to build a custom search page to help user-find the Accounts they want. Users will be able to search on Name, Description, and a custom comments field. Which…
The correct answer is C. SOSL is faster for tent searches. D. SOQL is able to return more records. This question asks about the distinctions between SOQL and SOSL for a custom search page needing to query across multiple text fields and return accounts.
Question
Universal Containers hires a developer to build a custom search page to help user-find the Accounts they want. Users will be able to search on Name, Description, and a custom comments field. Which consideration should the developer be aware of when deciding between SOQL and SOSL? Choose 2 answers
Options
- ASOSL is able to return more records.
- BSOQL is faster for text searches.
- CSOSL is faster for tent searches.
- DSOQL is able to return more records.
How the community answered
(55 responses)- A9% (5)
- B4% (2)
- C87% (48)
Why each option
This question asks about the distinctions between SOQL and SOSL for a custom search page needing to query across multiple text fields and return accounts.
This is incorrect because SOSL has a lower record limit (2,000 records) compared to SOQL (50,000 records).
This is incorrect; SOSL is specifically optimized for text searches, while SOQL is primarily for querying structured data based on specific field values.
SOSL (Salesforce Object Search Language) is specifically designed for efficient text-based searches across multiple fields and multiple objects, making it faster for keyword searches.
SOQL (Salesforce Object Query Language) has a higher record limit of up to 50,000 records, whereas SOSL has a lower limit of 2,000 records, making SOQL more suitable for potentially larger result sets.
Concept tested: SOQL vs. SOSL capabilities and limits
Source: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sfdc_soql_sosl_which_to_use.htm
Topics
Community Discussion
No community discussion yet for this question.