A customer's database, which is used as a source for a lookup table, is modified on a regular basis causing the data to
Posted: Fri Aug 26, 2022 9:56 am
A customer's database, which is used as a source for a lookup table, is modified on a regular basis causing the data to become invalid within five minutes. The databasecontains5,000,000 rows and is indexed on the field to be joined on and optimized for reading. How should the caching settings be configured for this lookup table?
A. Disable caching.
B. Enable caching with a setting of "20" in the "Number of results to cache" field.
C. Enable caching with a setting of "20" in the "Number of results to cache" field and set an invalidation schedule for every five minutes.
D. Enable Caching with a setting of "20" in the "Number of results to cache" field, set an invalidation schedule for every five minutes, and enable prefetch.
A. Disable caching.
B. Enable caching with a setting of "20" in the "Number of results to cache" field.
C. Enable caching with a setting of "20" in the "Number of results to cache" field and set an invalidation schedule for every five minutes.
D. Enable Caching with a setting of "20" in the "Number of results to cache" field, set an invalidation schedule for every five minutes, and enable prefetch.