Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily
basis, the majority of users at the company log in to Oracle BI every Monday to generate
the previous week’s sales report. The BI Administrator schedules cache purge and cache
seeding to improve report response times. How is this accomplished?
A.
Everyday before Data Warehouse refresh
B.
Every day after Data Warehouse refresh
C.
Every Monday early morning
D.
Every Monday late night
C is more appropriate in a business perspective.
D) is supposed to be correct, anyway the cache serves majority. However, the minor user( not users on Monday) can query the database directly instead of query cache with one setting?
I think C) is the correct answer. But can anyone justify why the suggested answer is D?
C
C