Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Certified Heroku Architect (Plat-Arch-206) Exam - Topic 1 Question 37 Discussion

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

Salesforce Certified Heroku Architect (Plat-Arch-206) Exam - Topic 1 Question 37 Discussion

Actual exam question for Salesforce's Salesforce Certified Heroku Architect (Plat-Arch-206) exam
Question #: 37
Topic #: 1
[All Salesforce Certified Heroku Architect (Plat-Arch-206) Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B, C, D

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

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Heroku Architect (Plat-Arch-206) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Emilio
6 months ago
Just to clarify, Heroku Connect does support filtering on syncs.
upvoted 0 times
...
Herschel
6 months ago
Wait, can D really restrict visibility like that? Seems odd.
upvoted 0 times
...
Lyla
7 months ago
C sounds right, using the Mapping Query Editor is super flexible.
upvoted 0 times
...
Sang
7 months ago
I think B could work too, but it seems more complicated.
upvoted 0 times
...
Rosann
7 months ago
A is the way to go for mapping filters!
upvoted 0 times
...
Gwenn
7 months ago
Sharing Rules seem more related to Salesforce permissions, so I doubt option D is the right approach for syncing data.
upvoted 0 times
...
Ena
8 months ago
I think the Mapping Query Editor is a feature we covered, so option C sounds familiar, but I’m a bit confused about the specifics.
upvoted 0 times
...
Laurene
8 months ago
I'm not entirely sure, but I feel like filtering the data in the database, like in option B, might also work.
upvoted 0 times
...
Felicitas
8 months ago
I remember we discussed using mapping filters in class, so I think option A could be the right choice.
upvoted 0 times
...
Kate
8 months ago
Ah, I see. This is all about controlling what data gets synced to Salesforce. I think option A is the cleanest solution - just set up the mapping filter and let Heroku Connect handle the rest.
upvoted 0 times
...
Jose
8 months ago
Okay, I've got this. The key here is that we only need to sync a subset of the rows, so filtering the data is the way to go. I'd go with option B and provide an alternative table or view for the sync.
upvoted 0 times
...
Alfred
8 months ago
Hmm, I'm a bit unsure about this one. I'm not super familiar with Heroku Connect, so I'll have to think it through carefully. Maybe option C with the Mapping Query Editor could work, but I'm not sure.
upvoted 0 times
...
Maryann
8 months ago
This looks like a straightforward Heroku Connect question. I think option A is the way to go - adding a mapping filter to the table sync seems like the easiest solution.
upvoted 0 times
...
Laine
8 months ago
This is an interesting question. I'll need to draw on my knowledge of JD Edwards EnterpriseOne and database middleware to figure out the correct answers.
upvoted 0 times
...
Elenora
8 months ago
I kind of want to say it's option C because that seems familiar. It would make sense that if you're trying to delete something not there, you'd get an error.
upvoted 0 times
...
Murray
8 months ago
I've got this! The key is to identify which segments meet the 10% threshold for both revenue and assets. That will tell us which ones are reportable.
upvoted 0 times
...
Edelmira
8 months ago
I'm a bit confused on this one. I'll have to think it through carefully and review the different techniques before deciding.
upvoted 0 times
...
Darrin
1 year 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
Ahmed
11 months 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
...
Hoa
11 months ago
C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.
upvoted 0 times
...
Nguyet
12 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
...
...
Bernardine
1 year 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 year 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
Dacia
11 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
...
Reid
11 months ago
D) Place Sharing Rules on the records, and restrict visibility to only those rows that are needed.
upvoted 0 times
...
Avery
12 months ago
B) Filter the data in the database, and provide an alternative table or view for use in the sync.
upvoted 0 times
...
...
Lewis
1 year 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
12 months ago
C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.
upvoted 0 times
...
Junita
1 year ago
That's a good point. Filtering at the database level gives more control over the data.
upvoted 0 times
...
Jesus
1 year ago
B) Filter the data in the database, and provide an alternative table or view for use in the sync.
upvoted 0 times
...
...
Alease
1 year 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
1 year ago
B) Filter the data in the database, and provide an alternative table or view for use in the sync.
upvoted 0 times
...
Georgene
1 year ago
I think option C is the way to go. It allows for more flexibility in filtering the data.
upvoted 0 times
...
Bobbye
1 year ago
C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.
upvoted 0 times
...
Ty
1 year 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 year ago
C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.
upvoted 0 times
...
Kimi
1 year 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
1 year 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
1 year 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
1 year ago
I think the answer is C) Use the Heroku Connect Mapping Query Editor, and add filters to the query.
upvoted 0 times
...

Save Cancel