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

Questions 16–20

1. 16application · medium

   A data architect needs to provide a nightly export of all records from a custom object to an external system. The export volume is around 1 million records per night. The external system requires the data to be delivered as a CSV file. Which export method is most efficient and reliable?

   • AUse the REST API to query all records in a single call and save as CSV.
   • BUse a third-party ETL tool that uses the SOAP API to export data.
   • CUse the Bulk API to query the records and then write the results to a CSV file, scheduled via a cron job.
   • DUse the Data Export Service to schedule a nightly export and then have the external system pull the CSV from the Salesforce instance.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which approach helps minimize record lock contention during a large data import?

   • ADisabling all validation rules and triggers before the import.
   • BIncreasing the number of concurrent batches to speed up the load.
   • CUsing external IDs to identify records uniquely.
   • DProcessing records in a serial manner to avoid simultaneous updates to the same records.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A data architect needs to export 10 million records from a custom object to a data warehouse. The export must complete within 24 hours and should not impact user performance. Which approach is most appropriate?

   • AUse the SOAP API to query all records in a single call.
   • BUse a third-party tool that uses the REST API to export records.
   • CUse the Data Export Service to schedule a weekly export and then download the file.
   • DUse the Bulk API to query the data in batches and export to the warehouse.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A company is planning to migrate 3 million records from a legacy system to Salesforce. The migration must be completed over a weekend to minimize business disruption. The team has limited experience with APIs and prefers a tool with a graphical interface. Which approach is most appropriate?

   • AUse the Data Import Wizard to load the records in multiple sessions.
   • BUse the SOAP API with a simple script to load records one by one.
   • CUse a third-party ETL tool that provides a graphical interface and uses the Bulk API in the background.
   • DUse the Bulk API directly with a custom script, even though the team has limited API experience.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Which Salesforce feature is designed for scheduled, full or incremental exports of data for backup or archival purposes?

   • AData Export Service
   • BBulk API
   • CWorkbench
   • DREST API
   Reveal Solution Discussion Select an answer first