Q7: How do you address cache coherency?
A: A candidate's answer will vary, but should at least mention the use of multi-server, in-memory caches, and caches that may be quasi-memory, such as a SQL server database. They should understand that a SQL server database is where the data gets maintained in memory by the SQL server predictive caching. The candidate should be aware of problems with cached objects not being in-sync across multiple servers, and the need to clear cached objects when cache coherency is critical.
Author: Ashley Mulero