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.
Every day before Data Warehouse refresh
B.
Every day after Data Warehouse refresh
C.
Every Monday early morning
D.
Every Monday late night
Explanation:
Purge and reseed once a week after the reports have run to improve report
response time.
Answer is B
As per the business requirement, i guess answer C is more appropriate.
I Think b. With the option C is possible stale cache
Answer should be C
Not B because if everyday purging and seeding of data after daily ETL will result in New data on reports every Morning . But in question its mentioned that majority of user take out report of last week on Monday meaning they want the old data in the report ( the stale data) . So B in incorrect .
Hi sid123 and Rahul,
Answer is B. Majority of users meaning not all of them right… Lets say if there are 100 users out of which 70 users want to see the last weeks sales but other 30 users may want to see the latest data as and when the data gets refreshed. So our priority should be data quality.
Cache purging and cache seeding(run logical queries to seed the cache for last week sales) should be done everyday after data warehouse refresh.
the minor user( not users on Monday) can query the database instead of query cache with one setting?
Suppose that the answer is C. Then users will see the same report during the whole week. Data will not change until next Monday. So wy are we running ETL every day ! ETL wan be run on sunday only !
For me as we are running ETL every day, then answer is B