Salesforce Exam Heroku Architect Topic 1 Question 37 Discussion

Actual exam question for Salesforce's Heroku Architect exam

Question #: 37
Topic #: 1

A client wants to use Heroku Connect to sync data from a Heroku Postgres table toa Salesforce org. The client only needs to sync a specific subset of the rows in the table.

How should this be performed?

AAdd a mapping filter to the table when setting up the sync, and select appropriate criteria from the list.

BFilter the data inthe database, and provide an alternative table or view for use in the sync.

CUse the Heroku Connect Mapping Query Editor, and add filters to the query.

DPlace Sharing Rules on the records, and restrict visibility to only those rows that are needed.

Show Suggested Answer

Suggested Answer: B, C, D

by Daniela at May 20, 2024, 04:16 PM

Limited Time Offer

25%

Off

Get Premium Heroku Architect Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Darrin

29 days ago

Option E: Hire a team of trained squirrels to manually sync the data. It's the most organic solution, if you ask me.

upvoted 0 times

Nguyet

9 days ago

A) Add a mapping filter to the table when setting up the sync, and select appropriate criteria from the list.

upvoted 0 times

...

Bernardine

1 months ago

A is the obvious choice. Heroku Connect is designed for this kind of use case, why reinvent the wheel?

upvoted 0 times

...

Dolores

1 months ago

D, really? Sharing rules for this use case? That's like using a bazooka to kill a fly. Let's keep it simple and go with B.

upvoted 0 times

...

Lewis

1 months ago

B is the way to go. Filtering the data at the database level is more robust and efficient than relying on Heroku Connect's mapping features.

upvoted 0 times

Julianna

5 days ago

C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.

upvoted 0 times

...

Junita

16 days ago

That's a good point. Filtering at the database level gives more control over the data.

upvoted 0 times

...

Jesus

22 days ago

B) Filter the data in the database, and provide an alternative table or view for use in the sync.

upvoted 0 times

...

Alease

2 months ago

Option C looks good, but I'm not sure if the Mapping Query Editor is meant for filtering data. Seems a bit hacky to me.

upvoted 0 times

Joesph

24 days ago

B) Filter the data in the database, and provide an alternative table or view for use in the sync.

upvoted 0 times

...

Georgene

28 days ago

I think option C is the way to go. It allows for more flexibility in filtering the data.

upvoted 0 times

...

Bobbye

28 days ago

C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.

upvoted 0 times

...

Ty

1 months ago

A) Add a mapping filter to the table when setting up the sync, and select appropriate criteria from the list.

upvoted 0 times

...

Bernadine

1 months ago

C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.

upvoted 0 times

...

Kimi

2 months ago

A) Add a mapping filter to the table when setting up the sync, and select appropriate criteria from the list.

upvoted 0 times

...

Dottie

2 months ago

I agree with Dottie, option C makes the most sense because it allows for specific filtering of the data being synced.

upvoted 0 times

...

Willis

2 months ago

I disagree, I believe the correct answer is A) Add a mapping filter to the table when setting up the sync, and select appropriate criteria from the list.

upvoted 0 times

...

Dottie

3 months ago

I think the answer is C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.

upvoted 0 times

...