Salesforce Certified Heroku Architecture Designer — Question 18

A client's Heroku web application displays data that is fetched from a back-end file storage system. The client now wants this data to be viewable, but not editable, from their Salesforce org.
Which recommendation should an Architect make in this scenario?

Answer options

• A. Replicate the files to tables in a Heroku Postgres database, and use Heroku Connect to synchronize the tables to the Salesforce org.
• B. Store all file URLs in a Heroku Postgres table, and use Heroku Connect to synchronize the table to the Salesforce org.
• C. Replicate the files to tables in a Heroku Postgres database, and use Heroku External Objects to expose the tables to the Salesforce org.
• D. Replicate the files to the application's local filesystem, and use worker dynos to periodically sync them to the Salesforce org.

Correct answer: A

Explanation

The correct answer is A because replicating the files to a Heroku Postgres database and using Heroku Connect allows for seamless synchronization of the data with Salesforce, ensuring that it is viewable but not editable. Option B does not provide the same level of data structure for synchronization as tables do. Option C uses External Objects, which may not be necessary since the data needs to be fully replicated, and option D involves unnecessary complexity and potential latency in syncing data.