74580 A large data stored on the Cloud instance which takes 30 sec on the average for each user query. You are asked to build a cache in the bank's data center to speed up the queries where the average query latency should be 10 sec. The cache memory has access latency of 5 sec. If a cache is introduced, then any data can be delivered only from the cache to the application and not directly from the Cloud DB. [Marks: 5] (a) What is your expected hit rate in the cache to meet this aggressive average query latency target ? (b) You have to study the historical query pattern and do a feasibility study to understand whether caching will work before introducing the cache of the right size. Discuss 3 insights you would be looking for in this study with reasons to help you design the cache.

45 A large data analysis application in a bank is built on a Cloud based MongoDB cluster. The Analytics team runs spend analysis on the transaction data stored on the Cloud instance which takes 30 sec on the average for each user query. You are asked to build a cache in the bank's data center to speed up the queries where the average query lateney should be 10 sec. The cache memory has access latency of 5 sec. If a cache is introduced, then any data can be delivered only from the cache to the application and not directly from the Cloud DB. (Marks: 51 (a) What is your expected hit rate in the cache to meet this aggressive average query latency target ? (b) You have to study the historical query pattern and do a feasibility study to understand whether caching will work before introducing the cache of the right size. Discuss 3 insights you would be looking for in this study with reasons to help you design the cache