Compare and Contrast Various Techniques for Improving Performance When Migrating Large Data Volumes into Salesforce, Generating Reports and Dashboards, and Querying Large Data Sets in Salesforce. DATA-ARCHITECT Practice Questions (Page 4)

Questions 16–16

1. 16application · medium

   A developer is writing a query to find all Accounts where the Description field is null. The Account object has 1 million records, and the query is slow. Which approach is most likely to improve query performance?

   • AAdd a checkbox field 'Has_Description__c' that is maintained by a workflow and filter on that field.
   • BUse the 'IN' clause with a list of empty strings.
   • CUse a formula field that returns a value when Description is null and filter on that field.
   • DAdd a custom index on the Description field.
   Reveal Solution Discussion Select an answer first