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

Questions 1–5

1. 1expert · hard

   A data architect is importing a complex hierarchy: Parent Account, Child Account, Contacts, Opportunities, and custom object 'Project__c' that has lookups to both Account and Opportunity. The source system provides external IDs for all objects. The import must be completed in the shortest time possible while ensuring data integrity. Which load strategy is most efficient?

   • ALoad all objects in a single bulk job with multiple batches, using external IDs.
   • BLoad Parent Accounts, then Child Accounts, then Contacts, then Opportunities, then Project__c, using external IDs.
   • CLoad all objects in parallel, using external IDs in lookup fields, and rely on the Bulk API to resolve relationships.
   • DLoad Opportunities first, then Accounts, then Contacts, then Project__c, using external IDs.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A company is importing a small set of 5,000 records that have complex parent-child relationships and also need to trigger a series of workflow rules and validation rules. The business wants to minimize errors and be able to easily identify which records failed. Which import technique is most appropriate?

   • AUse the Data Import Wizard to load each object sequentially, starting with parents.
   • BUse the Bulk API with a single job and batch size of 10,000.
   • CUse the SOAP API with a custom script to load all records in a single transaction.
   • DUse the Bulk API with parallel jobs to load all objects at once.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   When using parallel load to import data into Salesforce, what is a key consideration to manage?

   • AUsing only one API connection to avoid exceeding limits.
   • BDisabling all triggers and workflows to improve performance.
   • CAvoiding concurrent updates to the same records to prevent lock contention.
   • DEnsuring that all batches are processed in a strict sequential order.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is a primary consideration when importing a large dataset into Salesforce during business hours?

   • AThe import may cause record locks and performance degradation for other users.
   • BThe import will not be subject to API limits during business hours.
   • CThe import will have no impact on other users.
   • DThe import will be faster because the system is more active.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company is importing 10,000 records that have a self-referential hierarchy (e.g., Account.ParentId). The data includes multiple levels of hierarchy. The business wants to ensure that all records are imported with correct parent-child relationships. Which approach is most appropriate?

   • AUse the Data Import Wizard to load all records in one session.
   • BLoad records in multiple batches, starting with the top-level records (no parent), then the next level, and so on, using external IDs for ParentId.
   • CLoad all records in a single batch using the Bulk API, with ParentId set to the external ID of the parent.
   • DLoad all records in parallel using multiple bulk jobs, with ParentId set to the external ID.
   Reveal Solution Discussion Select an answer first