Salesforce Certified Data Architect — Question 36

Northern Trail Outfitters (NTO) needs to extract 50 million records from a custom object every day from its Salesforce org. NTO is facing query time-out issues while extracting these records.
What should a data architect recommend in order to get around the time-out issue?

Answer options

• A. Use a custom auto number and formula field to chunk records while extracting data,
• B. Use the Rest API to extract data as it automatically chunks records by 200.
• C. Use extract, transform, load (ETL) tool for extraction of records.
• D. Ask Salesforce support to increase the query timeout value.

Correct answer: C

Explanation

The correct answer is C because an ETL tool is specifically designed to handle large data volumes efficiently and can manage batch processing to avoid time-out issues. Options A and B may provide partial solutions but do not address the overall volume effectively. Option D is not a viable solution, as increasing the timeout limit does not resolve the underlying performance issues associated with large data queries.