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 80 Discussion

An existing app is experiencing performance degradation because of multiple executions of multiple, expensive SQL read queries. This SQL code cannot be optimized any further and the frequency of the execution of the queries cannot be reduced. Which two options should an Architect recommend in this scenario?
B) Add a read-only HerokuPostgres follower and C) Create a database caching layer
A) Hardcode the results of the query into app logic
D) Restart the Heroku Postgres server to reclaim cache

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

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

An existing app is experiencing performance degradation because of multiple executions of multiple, expensive SQL read queries. This SQL code cannot be optimized any further and the frequency of the execution of the queries cannot be reduced. Which two options should an Architect recommend in this scenario?

Show Suggested Answer Hide Answer
Suggested Answer: B, C

- https://devcenter.heroku.com/articles/using-sso-services-with-heroku#end-user-account-creation-and-removal


by Sueann at Aug 14, 2026, 12:54 AM

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
Vilma
3 days ago
Definitely go with option C, caching is key!
upvoted 0 times
...
Lilli
8 days ago
Restarting the server to reclaim cache seems like a temporary fix, but I doubt it's a long-term solution for performance degradation.
upvoted 0 times
...
Karl
13 days ago
Adding a read-only HerokuPostgres follower sounds familiar, but I can't recall if it really helps with performance issues like this.
upvoted 0 times
...
Martha
18 days ago
I'm not entirely sure, but hardcoding query results seems risky. What if the data changes?
upvoted 0 times
...
Leonardo
23 days ago
I remember discussing caching strategies in class, so I think creating a database caching layer could be a solid option.
upvoted 0 times
...

Save Cancel