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

Questions 6–10

1. 6foundation · easy

   What does it mean for a query filter to be 'selective' in Salesforce?

   • AThe filter uses a custom index on a formula field
   • BThe filter returns a small percentage of the total records
   • CThe filter excludes null values from the result set
   • DThe filter is applied after the query results are retrieved
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A developer is writing a query to find all contacts with a custom field that has a value of 'VIP'. The field is indexed, but the query is slow. The developer checks the Query Plan and sees that the index is not being used. What is the most likely reason?

   • AThe field is a formula field, and formula fields cannot be indexed
   • BThe query is missing the WITH SECURITY_ENFORCED clause
   • CThe query is using a negative operator, such as != 'Non-VIP'
   • DThe value 'VIP' is not selective; it matches a large percentage of records
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A developer is analyzing a query that filters on a custom field with a picklist of 10 values. The query is slow. The developer runs the Query Plan and sees that the index is not being used. What is the most likely reason?

   • AThe query is missing the ALL ROWS clause
   • BThe query is using a formula field instead of the picklist field
   • CThe picklist field is not indexed because it is a picklist
   • DThe filter value is not selective enough; the query returns more than 10% of the records
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A developer is optimizing a query that is used in a Lightning Web Component to display a list of accounts. The query filters on a custom field that is not indexed and returns a large result set. Which technique should the developer use to improve performance?

   • AIncrease the batch size in the LWC to load more records at once
   • BAdd a filter on a standard indexed field, such as CreatedDate, to narrow the result set
   • CUse the WITH USER_MODE clause to enforce sharing rules and improve performance
   • DUse a skinny table to store the frequently queried fields
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which combination of factors has the greatest impact on the performance of a SOQL query in Salesforce?

   • AThe number of users logged in and the API version used
   • BThe order of fields in the SELECT clause and the use of aliases
   • CThe length of the query string and the use of comments
   • DData volume, selectivity of filters, and available indexes
   Reveal Solution Discussion Select an answer first