試験CRT-450-JPN トピック1 問題178 スレッド
Salesforce CRT-450-JPNのリアル試験問題集
問題 #: 178
トピック #: 1
問題 #: 178
トピック #: 1
Universal Containers は開発者を雇ってカスタム検索ページを作成し、ユーザーが必要なアカウントを見つけられるようにします。ユーザーは、名前、説明、およびカスタム コメント フィールドで検索できます。
SOQL と SOSL のどちらを使用するかを決定する際に、開発者が注意すべき考慮事項はどれですか?
2つの答えを選択してください
SOQL と SOSL のどちらを使用するかを決定する際に、開発者が注意すべき考慮事項はどれですか?
2つの答えを選択してください
おすすめの解答：A,C 解答を投票する
SOSL and SOQL are two different types of search languages in Salesforce. SOSL is a programmatic way of performing a text-based search against the search index, while SOQL is the equivalent of a SELECT SQL statement and searches the org database1. The developer should consider the following factors when deciding between SOQL and SOSL2:
* The number of records to be returned: SOSL can return up to 2,000 records from multiple objects, while SOQL can return up to 50,000 records from a single object or from multiple objects that are related to one another1.
* The speed of text searches: SOSL is generally faster than SOQL for text searches, especially if the search expression uses a CONTAINS term. SOSL can tokenize multiple terms within a field and build a search index from this, which makes SOSL searches more efficient and relevant1.
* The knowledge of the object or field: SOSL is useful when the developer does not know which object or field the data resides in, and wants to retrieve data for a specific term across multiple objects and fields. SOQL is useful when the developer knows which objects the data resides in, and wants to retrieve data from a single object or from multiple objects that are related to one another1.
* The type of data to be retrieved: SOSL supports text, email, and phone fields, and can retrieve data that is in Chinese, Japanese, Korean, or Thai. SOQL supports number, date, or checkbox fields, and can retrieve data from big objects1. References:
* Introduction to SOQL and SOSL | SOQL and SOSL Reference | Salesforce Developers
* Difference between SOSL and SOQL search types - Salesforce
* The number of records to be returned: SOSL can return up to 2,000 records from multiple objects, while SOQL can return up to 50,000 records from a single object or from multiple objects that are related to one another1.
* The speed of text searches: SOSL is generally faster than SOQL for text searches, especially if the search expression uses a CONTAINS term. SOSL can tokenize multiple terms within a field and build a search index from this, which makes SOSL searches more efficient and relevant1.
* The knowledge of the object or field: SOSL is useful when the developer does not know which object or field the data resides in, and wants to retrieve data for a specific term across multiple objects and fields. SOQL is useful when the developer knows which objects the data resides in, and wants to retrieve data from a single object or from multiple objects that are related to one another1.
* The type of data to be retrieved: SOSL supports text, email, and phone fields, and can retrieve data that is in Chinese, Japanese, Korean, or Thai. SOQL supports number, date, or checkbox fields, and can retrieve data from big objects1. References:
* Introduction to SOQL and SOSL | SOQL and SOSL Reference | Salesforce Developers
* Difference between SOSL and SOQL search types - Salesforce
答え修正ちゃん 2024-01-29 01:50:50
コメント
答え修正ちゃん
2024-01-29 13:50:50SOQLはより多くのレコードを返すことができるが解答
他人の解答コメントを賛成するのも、その解答に一票を入れることになります。したがって、すでに同じ意見の投票コメントが存在する場合、新規コメントをする代わりに賛成することもできます。
コメントを通報する
コメント中
今すぐ 新規登録 / ログイン （無料です）。