Salesforce Certified Data Architect — Question 15

Universal Containers (UC) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.
What data extraction strategy should a data architect use for maximum performance?

Answer options

• A. Utilize PK Chunking with the Bulk API.
• B. Install a third-party AppExchange tool.
• C. Use the Bulk API in parallel mode.
• D. Call the REST API in successive queries.

Correct answer: A

Explanation

The correct answer is A, as utilizing PK Chunking with the Bulk API allows for efficient handling of large datasets by breaking the data into manageable chunks. Options B and C, while they could be effective, may not provide the same level of performance as the PK Chunking method. Option D is the least efficient, as calling the REST API in successive queries would likely result in slower performance due to the overhead of multiple requests.