A developer is writing a query to find all accounts with a custom field that has a value of 'Active'. 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?

The field is a picklist, and picklist fields cannot be indexed

The query is using a negative operator, such as != 'Inactive'

The field has a high number of null values, making the index less effective

The value 'Active' is not selective; it matches a large percentage of records

Which technique can improve query performance by reducing the amount of data that must be scanned?

Using a selective filter on an indexed field

Using a non-selective filter on a non-indexed field

Adding more fields to the SELECT clause

What is the purpose of a skinny table in Salesforce?

To store deleted records for audit purposes

To provide a read-only copy of an object for reporting

To compress data to save storage space

To store only a subset of fields and rows for faster queries

A developer is troubleshooting a slow SOQL query in a sandbox. The query runs fine in production but is slow in the sandbox. Which tool should the developer use to compare the query performance between the two environments?

The Performance tab in the Developer Console

Debug logs with query plan information

The Optimizer in the Salesforce Setup menu

Query Plan in the Developer Console

SalesforceCertified Platform Developer II

Domain 5Objective 2

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

Part of the PERFORMANCE domain, which accounts for 12% of the PLATFORM-DEVELOPER-II exam.

16questions here

4free pages

4concepts

12%of the exam

Questions 11–15

11application · medium
A developer is writing a query to find all accounts with a custom field that has a value of 'Active'. 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?
Select an answer first
12foundation · easy
Which technique can improve query performance by reducing the amount of data that must be scanned?
Select an answer first
13foundation · easy
What is the purpose of a skinny table in Salesforce?
Select an answer first
14foundation · easy
Which tool in Salesforce provides a visual representation of how a query will be executed, including index usage and estimated cost?
Select an answer first
15application · medium
A developer is troubleshooting a slow SOQL query in a sandbox. The query runs fine in production but is slow in the sandbox. Which tool should the developer use to compare the query performance between the two environments?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PLATFORM-DEVELOPER-II

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Salesforce. “PLATFORM-DEVELOPER-II” is a trademark of its owner, used for identification only.