Your customer has indicated that the data displayed on a particular dashboard is not refreshed at a sufficient rate. You know that some(but not all) of the data in the underlying data warehouse is updated hourly the rest of the data is updated daily.
A.
Turn off caching on the hourly updated physical tables.
B.
Turn off caching on the hourly updated logical tables.
C.
Reduce cache expiration time on all physical tables to reflect the data update frequency
D.
Employ use of an event polling table to force a cache refresh of the hourly updated data
E.
Restructure the logical business model such that physical sources with different refresh rates are not associated within a logical join
F.
refer to NQQuery.log to determine the location of the cache-data files(s) and write a script to periodically remove these cache files