If you run the below commands in your worksheet, what will happen?
CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE
STUDENT_TABLE_CLONE
CLONE STUDENT_TABLE;

You ran the below query. I have a warehouse with auto suspend set at 5 seconds
SELECT * FROM INVENTORY;
The query profile looks like as below. Please see below 'Percentage scanned from cache' is 0%

You ran the query again before 5 seconds has elapsed and the query profile looks as below. Look at the 'Percentage scanned for cache', it is 75%

You ran the query again after 5 seconds. The query profile looks as below. Look at the 'Percentage scanned from cache', it is zero again.

Why is this happening?

You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data.
What is the best option?

In this scenarios, files are constantly getting ingested in an external stage, the files are between 1 and 4 MB. You want to load the data immediately into a table without any human intervention.
What will you use?

One of your joins is taking a lot of time. The query profile view looks like this.
What may be the issue?