Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.

Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.
A . After the ETL run, execute the identical queries so that they remain in the result cache
B. After the ETL run, resize the warehouse to a larger warehouse
C. After the ETL run, copy the tables to another schema for the business users to query

View Answer

Answer: A

Explanation:

Please note the key word here which is IDENTICAL queries. When a query is run the first time, and the same query is run the second time it picks up the results from the query result cache and it does not cost you any compute. The query result cache is valid for 24 hours and it gets extended for another 24 hours, every time you access it(even if you access it at 23 hours 59 seconds).