Describe the Considerations for Query Performance. PLATFORM-DEVELOPER-II Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   How do standard indexes affect query performance in Salesforce?

   • AThey increase the size of the database and slow down all queries
   • BThey are only available on custom objects
   • CThey are automatically used for all queries on indexed fields
   • DThey can speed up queries when filters on indexed fields are selective
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A developer notices that a SOQL query filtering on a custom field with a null value is performing a full table scan. The field is indexed. What is the most likely cause and the best solution?

   • AThe field is not selective enough because most records have null values; consider using a different filter or a formula field
   • BThe custom field is not marked as 'Indexed' in the setup; check the field definition and enable indexing
   • CThe query uses a negative operator (e.g., !=) which prevents index usage; rewrite the query to use a positive filter
   • DThe query is missing the WITH SECURITY_ENFORCED clause; add it to enable index usage
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A developer is writing a SOQL query that will be used in a batch job to process millions of records. The query filters on a standard field that is not indexed. What is the best approach to ensure the query performs well?

   • AFilter on a different, indexed field first to narrow the result set
   • BUse the query in a batch job with a small batch size to avoid timeouts
   • CUse the WITH SYSTEM_MODE clause to bypass sharing rules and improve performance
   • DAdd a custom index on the standard field
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A developer is optimizing a query that filters on a custom field that is not indexed. The query is used in a batch job that processes records in chunks. Which technique should the developer use to improve performance?

   • AUse the WITH SYSTEM_MODE clause to bypass sharing rules
   • BUse the query in a batch job with a larger batch size to process more records at once
   • CAdd a custom index on the field
   • DFilter on a different, indexed field first to narrow the result set
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which factor most directly determines whether the Salesforce query optimizer can use an index to improve a query's performance?

   • AThe number of fields in the SELECT clause
   • BThe total number of records in the object
   • CThe selectivity of the filter conditions
   • DThe order of fields in the WHERE clause
   Reveal Solution Discussion Select an answer first