Salesforce Certified Heroku Architecture Designer — Question 10

A client wants to use Heroku Connect to sync data from a Heroku Postgres table to a Salesforce org. The client only needs to sync a specific subset of the rows in the table.
How should this be performed?

Answer options

• A. Add a mapping filter to the table when setting up the sync, and select appropriate criteria from the list.
• B. Filter the data in the database, and provide an alternative table or view for use in the sync.
• C. Use the Heroku Connect Mapping Query Editor, and add filters to the query.
• D. Place Sharing Rules on the records, and restrict visibility to only those rows that are needed.

Correct answer: D

Explanation

The correct answer is D because Sharing Rules can effectively restrict access to specific records, ensuring that only the required rows are synced. Options A and C suggest filtering methods that do not align with the requirement of limiting visibility at the record level, while B involves creating a new table or view, which may not be necessary or efficient for this task.