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 3)

Questions 11–15

1. 11foundation · easy

   A report runs slowly because it scans a large object. Which field characteristic can be used to improve report performance by allowing the database to quickly locate matching records?

   • AFormula field
   • BIndexed field
   • CCurrency field
   • DPicklist field
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which query characteristic is essential for a SOQL query to efficiently use a custom index on a large object?

   • AThe query must include all fields
   • BThe query must be selective
   • CThe query must avoid using ORDER BY
   • DThe query must use a formula field
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data architect is migrating 5 million legacy Account records into Salesforce using the Bulk API. The migration must complete within a 6-hour maintenance window. The initial run with a batch size of 200 records per batch is projected to take 9 hours. The architect has already confirmed that the target org has sufficient API request limits and that no Apex triggers or validation rules will be deployed during the migration. Which change is most likely to reduce the total migration time to fit the window?

   • AIncrease the batch size to 10,000 records per batch.
   • BDecrease the batch size to 100 records per batch.
   • CRun multiple Bulk API jobs in parallel, each processing a distinct subset of the data.
   • DSwitch to the SOAP API with a batch size of 200 records per call.
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A developer is writing a SOQL query to retrieve Cases created in the last 90 days for a customer portal. The Case object has 10 million records. The query filters on the CreatedDate field and the AccountId field. The query currently times out. Which change is most likely to improve query performance?

   • AFilter on the AccountId field first in the WHERE clause.
   • BUse the Id field in the WHERE clause instead of AccountId.
   • CAdd an ORDER BY clause on the CreatedDate field.
   • DAdd the AccountId field to a custom index or use a skinny table that includes AccountId and CreatedDate.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which technique can reduce the amount of data processed by a dashboard component, thereby improving dashboard performance?

   • ALimiting the report scope with filters
   • BRemoving all filters
   • CUsing a larger date range
   • DAdding more columns to the report
   Reveal Solution Discussion Select an answer first