Answer D is valid because using Bulk API 2.0 for both inserting and querying data can meet the requirements of loading and extracting large volumes of data in a day. Bulk API 2.0 is a RESTful API that allows creating, updating, deleting, or querying millions of records asynchronously by uploading or downloading CSV or JSON files. Bulk API 2.0 has several advantages over Bulk API 1.0, such as:
It does not count against the daily limit of 5,000 batches per rolling 24-hour period.
It supports PK Chunking for queries, which automatically splits large data sets into manageable chunks based on the primary key.
It simplifies the job lifecycle and reduces the number of API calls needed to perform a bulk operation.
Answer A is not valid because using Bulk API 2.0 for inserting data and REST API for querying data is not an optimal solution for handling large volumes of data in a day. REST API is a synchronous API that allows creating, updating, deleting, or querying individual records or small batches of records using HTTP methods. REST API has several limitations and drawbacks for this use case, such as:
It counts against the daily limit of 15,000 API requests per 24-hour period.
It does not support PK Chunking for queries, which means that large data sets may exceed the query timeout or heap size limits.
It requires more API calls and processing time to perform a bulk operation than Bulk API 2.0.
Answer B is not valid because using Bulk API 1.0 for both inserting and querying data is not a feasible solution for handling large volumes of data in a day. Bulk API 1.0 is a SOAP-based API that allows creating, updating, deleting, or querying millions of records asynchronously by uploading or downloading XML or CSV files. Bulk API 1.0 has several limitations and drawbacks compared to Bulk API 2.0, such as:
It counts against the daily limit of 5,000 batches per rolling 24-hour period, which may not be enough to load and extract 90M and 30M records respectively.
It does not support JSON format for data files, which may not be compatible with some external systems or applications.
It requires more API calls and complexity to manage the job lifecycle and handle errors or retries than Bulk API 2.0.
Answer C is not valid because using Bulk API 1.0 for inserting data and REST API for querying data is not a suitable or reliable solution for handling large volumes of data in a day. As explained above, both Bulk API 1.0 and REST API have limitations and drawbacks that may affect the performance, efficiency, and scalability of the integration.