Data-Architect Exam Dumps | Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company

<< Prev Question Next Question >>

Question 53/117

Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.
An Architect has been tasked with optimizing the data load time.
What should the Architect consider to achieve this goal?

A. Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

B. Directly leverage Salesforce-to-Salesforce functionality to load Case data.

C. Load the data in multiple sets using Bulk API parallel processes.

D. Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.

Recent Comments (The most recent comments are at the top.)

Sky - Apr 25, 2024

C

pre-processing and cleansing all sounds fancy but the question is about optimizing data load time of 6 million records.

Data Loader is supported for loads of up to 5 million records.
https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/when_to_use_the_data_loader.htm

With Bulk API you can do 150 million records in 24 hour rolling period.
150,000,000 (15,000 batches x 10,000 records per batch maximum)

Bulk API is optimized to load or delete a large number of records asynchronously. It is faster than the SOAP-based API due to parallel processing and fewer network round-trips. By default, Data Loader uses the SOAP-based API to process records.

test - Jan 15, 2024

Option C: Load the data in multiple sets using Bulk API parallel processes.

Reason: The Bulk API is specifically designed for handling large volumes of data efficiently. By loading the data in multiple sets and utilizing parallel processing capabilities, you can significantly reduce the time required for migrating 6 million Case records, making it the most effective choice for this large-scale data migration task.

Question 53/117

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File