Heroku-Architect Practice Test

Salesforce Spring 25 Release
184 Questions

Anexisting 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?

A. Hardcode the results of the query into app logic

B. Add a read-only HerokuPostgres follower

C. Create a database caching layer

D. Restart the Heroku Postgres server to reclaim cache

B.   Add a read-only HerokuPostgres follower
C.   Create a database caching layer

Heroku-Architect Practice-Test - Home Previous
Page 14 out of 184 Pages