A client is building a system that will sync data from multiple Salesforce orgs to a singleHeroku Postgres database. This system also needs to push the synced data to an external data warehouse for analytics processing. Which solution meets all of the requirements in this scenario?
Suggested Answer: D
Get Premium Salesforce Certified Heroku Architect (Plat-Arch-206) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
-https://devcenter.heroku.eom/articles/private-spaces#trusted-ip-ranges
19 comments · newest first
AD
Adrianna
11 months ago
Isn't using an ETL tool a bit overkill for this?
RA
Raul
11 months ago
Option D looks solid too, but I'm leaning towards B.
TE
Tequila
11 months ago
Wait, can Heroku Connect really handle all that?
BR
Brandon
11 months ago
I disagree, A seems more straightforward.
LA
Lavera
11 months ago
I think option B is the best choice here.
CO
Cordelia
12 months ago
I’m leaning towards option D since it mentions both Heroku Connect and an ETL tool, but I’m not completely confident about the details.
EL
Eladia
12 months ago
I feel like using an ETL tool is important for pushing data to the external warehouse, but I can't recall which options include that.
BR
Brandee
1 year ago
I think option B sounds familiar because it mentions Salesforce Connect, which I practiced with in a similar question.
NI
Nikita
1 year ago
I remember studying Heroku Connect, but I'm not sure if it can handle syncing from multiple Salesforce orgs directly.
CL
Cletus
1 year ago
I'm leaning towards option B. Separating the Salesforce to Postgres sync and the Postgres to data warehouse sync seems like a cleaner approach than trying to do it all in one step.
SE
Serina
1 year ago
Option D looks promising, as it uses Heroku Connect for the Salesforce to Postgres sync, and then an ETL tool for the Postgres to data warehouse sync. That seems like a comprehensive solution.
MA
Marcos
1 year ago
I'm a bit confused by the different integration options presented. I'll need to carefully review the details of each one to determine which best meets all the requirements.
EL
Eloisa
1 year ago
This seems like a straightforward question. I think option A is the best solution since it uses Heroku Connect to sync data across all the required systems.
VI
Vincent
1 year ago
I think option A is the best solution.
PE
Pearline
1 year ago
Ha, I bet the exam writers had a field day coming up with these options. Option A sounds like the 'Voltron' of solutions - it can do it all!
BU
Buddy
1 year ago
Option A sounds like the 'Voltron' of solutions - it can do it all!
CH
Chan
1 year ago
Hmm, Option B looks interesting, but it seems a bit convoluted with the multiple sync steps. I think I'd prefer a more streamlined solution like Option A or D.
CH
Cherry
1 year ago
I'd go with Option D. Heroku Connect is great for the Salesforce to Postgres sync, and then using an ETL tool to push to the external warehouse is a reliable approach.
CA
Carline
1 year ago
Option A seems like the most comprehensive solution. Heroku Connect can handle the data sync between Salesforce and Postgres, and then it can also push the data to the external warehouse. Seems like a one-stop shop for this scenario.