Salesforce Certified Platform Developer II — Question 38

Customer billing data must be added and updated into Salesforce from a remote system on weekly basis. Additionally, customer activity information must be extracted from Salesforce and put it into an on-premises data warehouse on a weekly basis.
Which approach should be used to import data into Salesforce and export data out of Salesforce, taking into consideration that these imports and exports can interfere with end-user operations during business hours and involve large amounts of data?

Answer options

• A. Batch Apex, where Salesforce pushes data to and pulls data from the remote systems
• B. Replication via third-party ETL to push data into Salesforce and pull data out in batches
• C. Salesforce Connect to push data to and pull data from the remote systems
• D. Call-in directly from each remote system to Salesforce APIs to push and pull the data

Correct answer: C

Explanation

The correct answer is C, as Salesforce Connect allows real-time integration with external systems without affecting the performance of Salesforce during business hours. Option A, Batch Apex, is not suitable since it can lead to delays and potential interference with user operations. Option B, while using ETL, may also disrupt operations and is less efficient for real-time needs. Option D involves direct API calls, which could lead to scalability issues and higher risk of impacting performance.