Given a Scenario, Analyze the Implications and Design Considerations of Large Data and Transaction Volumes. AGENTFORCE-SERVICE-CONSULTANT Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   A consultant is reviewing a Salesforce org with a large volume of records. Which factor is most directly impacted by the total number of records stored in the org?

   • AMaximum number of custom fields per object
   • BStorage consumption and data storage limits
   • CNumber of active users in the org
   • DNumber of Apex classes allowed in the org
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A company needs to update a custom field on 5 million Contact records based on data from an external system. The update must complete within a few hours and should not impact user-facing performance. Which approach should be used?

   • ARun a scheduled job that updates records one by one.
   • BUse the REST API to update all records in one call.
   • CUse a single Apex trigger to update all records in one transaction.
   • DRun an Apex batch job with a batch size of 200 records per batch.
   Reveal Solution Discussion Select an answer first
4. 13expert · hard

   A company has a custom object with 30 million records. A nightly batch job queries this object using a filter on a custom field that has low selectivity (only 3 distinct values). The job is slow and consumes excessive CPU. The developer added a custom index on the field, but performance did not improve. What is the most likely reason?

   • AThe custom index is not enabled for the object.
   • BThe index is not used because the field has low selectivity, and the query optimizer chooses a full table scan.
   • CThe batch job is using the 'QueryAll' method, which bypasses indexes.
   • DThe query is using a non-selective filter on the Id field.
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   An integration syncs 1 million records from an external system to Salesforce nightly. The integration currently uses REST API calls in a loop, causing API limits to be exceeded and the sync to fail. The team needs to redesign the integration to handle the volume reliably. Which approach should they take?

   • AUse SOAP API with a loop and add a delay between calls.
   • BUse a single REST API call with all 1 million records.
   • CIncrease the API concurrency limit by contacting Salesforce support.
   • DUse Bulk API 2.0 with batched records and implement error handling for failed batches.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A service organization stores 50 million Account records. A nightly Apex batch job updates a custom field on all Accounts with a 'LastActivityDate' value. The job recently started timing out and consuming excessive CPU. The developer suspects the SOQL query in the batch start method is performing a full table scan. Which design change would most directly address the performance issue?

   • AIncrease the batch size to 5000 records per batch execution.
   • BAdd a custom index on the 'LastActivityDate' field and rewrite the query to filter on that field.
   • CUse the 'QueryAll' method in the batch start to include deleted records.
   • DMove the batch job to run on a weekend to avoid peak usage.
   Reveal Solution Discussion Select an answer first