A.Indefinitely

B.Until the result_cache expires

C.Until the expiration time is exceeded

D.Until the retention_time is met

A.Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B.Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

C.Clustering keys sort the designated columns over time, without blocking DML operations

D.Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

A.The query has been run within 24 hours of the previously-run query

B.The new query is run using the same virtual warehouse as the previous query

C.Micro-partitions have been reclustered since the query was last run

D.The user has the appropriate privileges on the objects associated with the query

E.The query includes a User Defined Function (UDF)

A.JSON

B.CSV

C.XML

D.AVRO

E.Parquet

F.ORC

A.If multiple users are using the same virtual warehouse

B.If the referenced data in the table has changed

C.If the virtual warehouse has been suspended

D.If the query contains a deterministic function