DATA-ARCHITECT practice question 30 of 35

Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?

Full set: 257 questions
Answer options
A: Use the SOAP API to export data.
B: Utilize the Bulk API to export the data. Correct answer
C: Use GZIP compression to export the data.
D: Schedule a Batch Apex job to export the data.
Correct Answer:
B. Utilize the Bulk API to export the data.
Explanation

The Bulk API is designed specifically for asynchronously processing large volumes of data, such as exporting one million records. It works by creating jobs that are placed on a queue, and the data is processed in batches in the background. This asynchronous, parallel processing model is optimized for large data sets and avoids the per-transaction governor limits and HTTP timeouts that would affect synchronous APIs like the SOAP or REST API. It is the standard, recommended tool for large-scale data extraction and loading operations in Salesforce.

Why Incorrect

A. The SOAP API is a synchronous, transactional API designed for real-time operations on small numbers of records and would likely time out when attempting to query and retrieve a million records.
C. GZIP compression reduces the payload size for faster network transfer but does not solve the underlying issue of server-side query processing timeouts, which is the primary concern addressed by the Bulk API's asynchronous nature.
D. A Batch Apex job is a custom code solution for processing large data sets. While possible, it is more complex to implement and maintain than using the standard, purpose-built Bulk API for data extraction.

References

1. Salesforce Developer Documentation. Bulk API Developer Guide. "Bulk API is based on REST principles and is optimized for loading or deleting large sets of data. You can use it to query, queryAll, insert, update, upsert, or delete a large number of records asynchronously."

2. Salesforce Developer Documentation. Which API Should I Use?. "Use Bulk API to query, queryAll, insert, update, upsert, or delete a large number of records. Bulk API is asynchronous."

3. University of Washington. (2018). CSE 444: Database Systems Internals, Lecture 19: Parallel & Distributed Databases. "Parallel query processing is essential for large datasets to avoid bottlenecks and improve performance." The Bulk API's architecture embodies this principle.

Scroll to Top