Compare and Contrast Various Techniques and Considerations for Importing Data into and Exporting Data Out of Salesforce (e.g., Serial Load, Parallel Load, Deferred Sharing, Managing Locks, Handling Hierarchical Relationships, Bulk Load API Limits). DATA-ARCHITECT Practice Questions (Page 5)

Questions 21–24

1. 21application · medium

   A company is importing 500,000 custom object records that have a lookup to Account. The import runs during business hours and users are reporting that some records are temporarily inaccessible. The architect suspects sharing recalculation is causing delays. Which technique should be used to improve performance and reduce lock contention?

   • AUse the Bulk API with PK chunking to speed up the import, which automatically defers sharing.
   • BLoad the records in a sandbox first, then use a change set to deploy them to production.
   • CEnable Deferred Sharing on the custom object before the import and run a sharing recalculation job after the import completes.
   • DDisable all sharing rules for the custom object permanently to avoid recalculation.
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   During a large data import using the Bulk API, the architect receives errors indicating 'UNABLE_TO_LOCK_ROW' on Account records. The import is running in parallel with other jobs. Which action is most effective to reduce these lock errors?

   • AUse the SOAP API instead of the Bulk API to avoid lock errors.
   • BIncrease the batch size to reduce the number of batches and thus the number of lock attempts.
   • CReduce the number of concurrent jobs and schedule the import during off-peak hours.
   • DEnable Deferred Sharing on the Account object.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A data architect is planning a one-time import of 2 million Account records into a production org. The business requires the import to complete within a 4-hour maintenance window. The team has a single integration user and is using the Bulk API. Which approach best balances speed and reliability while staying within Bulk API limits?

   • ASplit the data into multiple bulk jobs and run them sequentially to avoid any lock contention.
   • BCreate several bulk jobs with moderate batch sizes and run them concurrently, monitoring for lock contention and adjusting if errors occur.
   • CRun a single bulk job with the largest possible batch size to minimize the number of batches.
   • DUse the SOAP API with a single threaded loop to insert records one by one, ensuring no locks are held for long.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A data architect is importing a hierarchy of records: Parent Account, Child Account, Contacts, and Opportunities. The source system provides unique external IDs for Accounts and Contacts. What is the recommended load order and technique to ensure child records reference the correct parents?

   • ALoad all objects in parallel, using external IDs in lookup fields to establish relationships.
   • BLoad Parent Accounts first, then Child Accounts, then Contacts, then Opportunities, using external ID fields in lookup columns.
   • CLoad Opportunities first, then Contacts, then Child Accounts, then Parent Accounts, using external IDs.
   • DLoad all records in a single batch, using the Bulk API's automatic relationship resolution.
   Reveal Solution Discussion Select an answer first