Why?

You have a medium warehouse with auto suspend of 5 minutes. You ran a query on table#1. After 10 minutes, you ran a query that joins table#1 and table#2, but you see that the query did not use data

cache.

Why?
A . When a warehouse is suspended, it may lose its data cache
B. The query that ran the second time is completely different from query that ran on table#1, hence it will not be able to use data cache
C. Joins cannot use any type of cache

View Answer

Answer: A

Explanation:

Again, be very careful. You may be tempted to choose the 2nd option but note that the question is not about result cache, it is about data cache. Data cache is the SSD cache that is part of the nodes of the virtual warehouse. If the warehouse is suspended, there is no guarantee that the same node will come up again. Hence you will not get the data cache when the warehouse resumes.