Salesforce
PDII · Question #304
PDII Question #304: Real Exam Question with Answer & Explanation
Sign in or unlock PDII to reveal the answer and full explanation for question #304. The question stem and answer options stay visible for context.
Question
As part of a new integration, a developer is asked to implement a new custom search functionality that is capable of performing unrestricted queries and can account for all values within a custom picklist field, Type__c, on the Opportunity object. The search feature must also account for NULL values. The organization-wide default for the Opportunity object is set to Public Read-Only, and a new custom index has been created for the Type__c field. There are more than 5 million Opportunity records within the environment, and a considerable amount of the existing records have NULL values for the picklist. Which technique should the developer implement to maximize performance when querying NULL values?
Options
- AUse a SOSL query to return ALL opportunities that have a value of NULL in any field.
- BUse the OR operator to combine WHERE clauses to strictly search for each value within the
- CPerform two SOQL queries; one to query Opportunities where Type__c != NULL, and another to
- DCreate a formula field that substitutes NULL values for a string of text, create an index for the
Unlock PDII to see the answer
You've previewed enough free PDII questions. Unlock PDII for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.